pg_dump patch: Allow -X'exclude table from dump by pattern'

From: Giuseppe Tanzilli - CSF <g(dot)tanzilli(at)gruppocsf(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: pg_dump patch: Allow -X'exclude table from dump by pattern'
Date: 2001-09-12 15:25:16
Message-ID: 3B9F7E5C.6030004@gruppocsf.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Ciao,
I had the need to exclude tables from the dump so I made this patch,
I do something like

pg_dump -X \"Test_*\" -X \"Devel*\" test

I'm not a C guru, but it work, the only thing I was unable to get rid
of is the dump of sequences for that table,

so I have to add -X tablename_id_seq

If you can suggest a way to work around it, I will try to fix it

hope it can be useful to the project

bye

--
-------------------------------------------------------
Giuseppe Tanzilli g(dot)tanzilli(at)gruppocsf(dot)com
CSF Sistemi srl phone ++39 0775 7771
Via del Ciavattino
Anagni FR
Italy

Attachment Content-Type Size
postgresql_pg_dump_exclude_patch_7.1.3 text/plain 6.1 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2001-09-12 15:39:50 Re: [JDBC] A proposal for jdbc.sgml(in 7.1.3 doc)
Previous Message Patrick Welche 2001-09-12 15:10:22 Re: factorial doc bug?