Friday, January 13, 2006

PostgreSQL - dumping a single table

$ pg_dump -Fp -U postgres --table=TABLENAME DATABASENAME > TABLENAME.sql

$ pg_dump -Fp -U postgres --table=TABLENAME DATABASENAME | gzip -c > TABLENAME.sql.gz

Useful for dumping out individual tables from a particular database in plain-text (SQL) format.

No comments: