Skip site navigation (1) Skip section navigation (2)

Patch for pg_dump: Multiple -t options and new -T option

From: "David F(dot) Skoll" <dfs(at)roaringpenguin(dot)com>
To: pgsql-patches(at)postgresql(dot)org
Subject: Patch for pg_dump: Multiple -t options and new -T option
Date: 2004-07-15 01:14:19
Message-ID: Pine.LNX.4.58.0407142112520.7150@shishi.roaringpenguin.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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(at)roaringpenguin(dot)com>    Roaring Penguin Software Inc.
+1 (613) 231-6599 ext. 100                 http://www.roaringpenguin.com/
For CanIt technical support, please mail: support(at)roaringpenguin(dot)com

Attachment: pg_dump.patch
Description: text/plain (7.3 KB)

Responses

pgsql-hackers by date

Next:From: Mark KirkwoodDate: 2004-07-15 01:43:38
Subject: Re: [HACKERS] Point in Time Recovery
Previous:From: Simon RiggsDate: 2004-07-14 23:36:59
Subject: Re: Release planning (was: Re: Status report)

pgsql-patches by date

Next:From: Christopher Kings-LynneDate: 2004-07-15 01:27:17
Subject: Re: add missing options to pg_dumpall
Previous:From: Simon RiggsDate: 2004-07-14 23:48:18
Subject: Re: [subxacts] Savepoint syntax

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group