I started an hours-long Postgres query in my
psql shell. Then, I got disconnected from the network and had to make a new
psql shell. If I look in
pg_stat_activity, I see that my query is still running. Can I connect to that query and get its output?
No. If the process is long use intermediate tables + screen.