docs:postgres:pg_dump

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
docs:postgres:pg_dump [2008/08/03 00:25] – external edit 127.0.0.1docs:postgres:pg_dump [2009/04/16 11:51] (current) – billh
Line 16: Line 16:
 pg_dump --data-only --file=/path/to/output/file.sql --no-owner --format=t \ pg_dump --data-only --file=/path/to/output/file.sql --no-owner --format=t \
 --table=sometable --no-privileges --disable-triggers -h hostname database --table=sometable --no-privileges --disable-triggers -h hostname database
 +</code>
 +
 +** Dump database schema, without owners or permissions: **
 +<code>
 +pg_dump --schema-only --no-owner --no-privileges -h hostname -U username databasename > dumpfile.sql
 </code> </code>
  • docs/postgres/pg_dump.1217744747.txt.gz
  • Last modified: 2009/04/16 11:51
  • (external edit)