This is an old revision of the document!
pg_dump
Tips
- you may need to specify the -i flag, to ignore differences in the database version and pg_dump executable; if this is done, it might be best to use a plain text format for the dump to be safe
Examples
Dump all tables, with acl/permissions, with create table scripts, to a plain text file with sql commands:
pg_dump --file=/path/to/output/file.sql --no-owner --format=p \ --disable-triggers -h hostname -d database
Dump a single table, without create table script, without ownerships, to a compressed format suitable for pg_restore:
pg_dump --data-only --file=/path/to/output/file.sql --no-owner --format=t \ --table=sometable --no-privileges --disable-triggers -h hostname -d database