Обсуждение: 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.

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. +