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
- exclude-table-data.patch.90 (text/plain)
- exclude-table-data.patch (text/x-patch)
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