Patch for pg_dump: Multiple -t options and new -T option - Mailing list pgsql-patches

From David F. Skoll
Subject Patch for pg_dump: Multiple -t options and new -T option
Date
Msg-id Pine.LNX.4.58.0407142112520.7150@shishi.roaringpenguin.com
Whole thread Raw
Responses Re: Patch for pg_dump: Multiple -t options and new -T option
Re: Patch for pg_dump: Multiple -t options and new -T option
List pgsql-patches
Attached is a patch against pg_dump version 7.4.3 that permits
multiple "-t" switches so that you can select more than one table (but
less than all) to dump.

It also adds a "-T" switch (long name "--exclude-table") that says
*not* to dump a specific table.  So:

        pg_dump -t table1 -t table2 db

will dump table1 and table2 only, whereas:

        pg_dump -T table1 -T table2 db

will dump all the tables *except* table1 and table2.

Tested briefly on my system; doesn't seem to break anything.

Regards,

David.

--
David F. Skoll <dfs@roaringpenguin.com>    Roaring Penguin Software Inc.
+1 (613) 231-6599 ext. 100                 http://www.roaringpenguin.com/
For CanIt technical support, please mail: support@roaringpenguin.com

Attachment

pgsql-patches by date:

Previous
From: Simon Riggs
Date:
Subject: Re: [subxacts] Savepoint syntax
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: add missing options to pg_dumpall