New pg_dump options: exclude tables/schemas, multiple all, wildcards
От | Greg Sabino Mullane |
---|---|
Тема | New pg_dump options: exclude tables/schemas, multiple all, wildcards |
Дата | |
Msg-id | 1137377967.3847.26.camel@localhost.localdomain обсуждение исходный текст |
Ответы |
Re: New pg_dump options: exclude tables/schemas, multiple all, wildcards
Re: New pg_dump options: exclude tables/schemas, multiple Re: New pg_dump options: exclude tables/schemas, multiple Re: New pg_dump options: exclude tables/schemas, multiple |
Список | pgsql-patches |
-----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-----
Вложения
В списке pgsql-patches по дате отправления: