Обсуждение: pg_restore question (-T and -t)
Hi, does anyone know if you can do multiple -T or -t (restore named trigger, restore name table) switches? In the docs for pg_restore it does not specify if it will accept more than one, but in the pg_dump docs the -n and -t switches allow multiples. Thanks, tony
Why not just try it! Answer: all -t switches after the first one are ignored. (And, no, "pg_restore --help" does not mention that). However with -l and -L, you have a much more powerful mechanism for specifying exactly which objects you want restored. > -----Original Message----- > From: pgsql-general-owner@postgresql.org [mailto:pgsql-general- > owner@postgresql.org] On Behalf Of Tony Caduto > Sent: Wednesday, December 31, 2008 1:50 PM > To: pgsql general > Subject: [GENERAL] pg_restore question (-T and -t) > > Hi, > does anyone know if you can do multiple > -T or -t (restore named trigger, restore name table) switches? > > In the docs for pg_restore it does not specify if it will accept more > than one, but in the pg_dump docs the -n and -t switches allow > multiples. > > Thanks, > > tony
Tony-
pgdump version 8.3 will dump multiple tables (with multiple -t)
http://www.postgresql.org/docs/8.3/interactive/app-pgdump.html
but I dont see the same multiple table functionality with pgrestore
http://www.postgresql.org/docs/8.3/interactive/app-pgrestore.html
you may have found a bug..
Martin Gainty
______________________________________________
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission.
> Date: Wed, 31 Dec 2008 15:49:39 -0600
> From: tony_caduto@amsoftwaredesign.com
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] pg_restore question (-T and -t)
>
> Hi,
> does anyone know if you can do multiple
> -T or -t (restore named trigger, restore name table) switches?
>
> In the docs for pg_restore it does not specify if it will accept more
> than one, but in the pg_dump docs the -n and -t switches allow multiples.
>
> Thanks,
>
> tony
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
It’s the same Hotmail®. If by “same” you mean up to 70% faster. Get your account now.
pgdump version 8.3 will dump multiple tables (with multiple -t)
http://www.postgresql.org/docs/8.3/interactive/app-pgdump.html
but I dont see the same multiple table functionality with pgrestore
http://www.postgresql.org/docs/8.3/interactive/app-pgrestore.html
you may have found a bug..
Martin Gainty
______________________________________________
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission.
> Date: Wed, 31 Dec 2008 15:49:39 -0600
> From: tony_caduto@amsoftwaredesign.com
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] pg_restore question (-T and -t)
>
> Hi,
> does anyone know if you can do multiple
> -T or -t (restore named trigger, restore name table) switches?
>
> In the docs for pg_restore it does not specify if it will accept more
> than one, but in the pg_dump docs the -n and -t switches allow multiples.
>
> Thanks,
>
> tony
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
It’s the same Hotmail®. If by “same” you mean up to 70% faster. Get your account now.
Martin Gainty wrote: > > Tony- > > pgdump version 8.3 will dump multiple tables (with multiple -t) > http://www.postgresql.org/docs/8.3/interactive/app-pgdump.html > > but I dont see the same multiple table functionality with pgrestore > http://www.postgresql.org/docs/8.3/interactive/app-pgrestore.html > > you may have found a bug.. Added to TODO: Add support for multiple pg_restore -t options, like pg_dump -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. +