| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers 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(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 | Content-Type | Size |
|---|---|---|
| pg_dump.patch | text/plain | 7.3 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Kirkwood | 2004-07-15 01:43:38 | Re: [HACKERS] Point in Time Recovery |
| Previous Message | Simon Riggs | 2004-07-14 23:36:59 | Re: Release planning (was: Re: Status report) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Kings-Lynne | 2004-07-15 01:27:17 | Re: add missing options to pg_dumpall |
| Previous Message | Simon Riggs | 2004-07-14 23:48:18 | Re: [subxacts] Savepoint syntax |