pg_restore question (-T and -t)

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.

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.
http://windowslive.com/online/hotmail?ocid=TXT_TAGLM_WL_hotmail_acq_broad1_122008

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