Re: New pg_dump options: exclude tables/schemas, multiple - Mailing list pgsql-patches

From Bruce Momjian
Subject Re: New pg_dump options: exclude tables/schemas, multiple
Date
Msg-id 200606141902.k5EJ2en20075@candle.pha.pa.us
Whole thread Raw
In response to New pg_dump options: exclude tables/schemas, multiple all, wildcards  (Greg Sabino Mullane <greg@turnstep.com>)
List pgsql-patches
This patch needs the modifications suggested in later emails,
specifically using regex and quering the server for matching objects.

URL added to TODO.

---------------------------------------------------------------------------

Greg Sabino Mullane wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> NotDashEscaped: You need GnuPG to verify this message
>
>
> Attached is a patch to hopefully make pg_dump a lot more useful.
> I started out by making it simply able to avoid dumping a single
> table, but, inspired by David Fetter's patch last November, also
> added in support for multiple items and limited wildcard matching.
>
> -n and -N control the schemas, and -t and -T control the tables.
>
> Wildcards can be a star at the start, the end, or on both sides
> of a term. The patch acts inclusively with conflicts: the -t
> option trumps the -N option.
>
> Some examples:
>
> To dump all tables beginning with the string "slony", plus
> all tables with the word "log" inside of them:
>
> pg_dump -t "slony*" -t "*log*"
>
> To dump all schemas except "dev" and "qa", and all tables
> except those ending in "large":
>
> pg_dump -N "dev" -N "qa" -T "*large"
>
> --
> Greg Sabino Mullane greg@turnstep.com
> PGP Key: 0x14964AC8 200601152100
> http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
> -----BEGIN PGP SIGNATURE-----
>
> iD8DBQFDyv9NvJuQZxSWSsgRAup9AKD110JJtJBYYPV5JxFROovfeddrSACg3IZ3
> BqczBImC8UCVmik3YFHvDeQ=
> =Y9zs
> -----END PGP SIGNATURE-----
>

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>                http://archives.postgresql.org

--
  Bruce Momjian   http://candle.pha.pa.us
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: FW: Win32 unicode vs ICU
Next
From: Bruce Momjian
Date:
Subject: Re: SQL/XML publishing function experimental patch II