PostgreSQL – Backup Table Only


for version >= 8.4.0:
pg_dump –column-inserts –data-only –table=<table> <database>

for version < 8.4.0:
pg_dump -D -t <table> <database>

 

source:

http://stackoverflow.com/questions/2857989/using-pg-dump-to-only-get-insert-statements-from-one-table-within-database

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s