Hi,
I want to use pg_dump to backup an entire Postgres database, including BLOB
data. Then I want to restore it on a different machine with a different db
owner and all the tables restored under that owner. I want the restore to
create the db and all the tables.
What are the commands to do this?
Thank you.