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_cad...@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