Loading

if I don't specify db name to pg_dump and just run pg_dump > file.sql

Sanjay Kumar

if I don't specify db name to pg_dump and just run
pg_dump > file.sql which db will it dump?

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Rajanikant Hawaldar5y ago
Accepted answer
dbname specifies the name of the database to be dumped. If this is not specified, the environment variable PGDATABASE is used. If that is not set, the user name specified for the connection is used.