pg_dump --exclude-table-data

Andrew Dunstan <andrew@dunslane.net>

From: Andrew Dunstan <andrew@dunslane.net>
To: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2011-08-23T20:07:56Z
Lists: pgsql-hackers

Attachments

Attached is an undocumented patch that allows a user to have pg_dump 
exclude data but not DDL for a table. One use case for this is a very 
large table that changes infrequently, and for which dumping data 
frequently would be wasteful and unnecessary. This is especially useful 
in conjunction with another patch (see next email) to do post-data items 
only or omit post-data items in pg_restore.

For those who are (like my clients :-) ) anxious to get their hands on 
this immediately, a backport patch is also attached which applies to 9.0 
sources, and applies with offsets to 8.4 sources.

cheers

andrew