pg_dump --exclude-table-data - Mailing list pgsql-hackers

From Andrew Dunstan
Subject pg_dump --exclude-table-data
Date
Msg-id 4E54089C.4030708@dunslane.net
Whole thread Raw
Responses Re: pg_dump --exclude-table-data
List pgsql-hackers
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

Attachment

pgsql-hackers by date:

Previous
From: Christopher Browne
Date:
Subject: Re: Getting rid of pg_pltemplate
Next
From: Robert Haas
Date:
Subject: Re: skip WAL on COPY patch