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.

Labels:

posted by Thomas at 11:46
Comments:

Post a Comment

Back to tgharold.com: Tech Blog