I used command
pg_dump -C -h remotehost -U remoteuser db_name | psql localhost -U localuser
to copy database on remote server to my local machine.
Can I somehow retreive the dump obtained after the first part of the command, i.e.
pg_dump -C -h remotehost -U remoteuser db_name
is executed? Can it be stored in some temporary location?