On Mon, Oct 6, 2008 at 3:24 PM, Harold A. Giménez Ch. <[EMAIL PROTECTED]> wrote: > > On Mon, Oct 6, 2008 at 5:02 PM, Emi Lu <[EMAIL PROTECTED]> wrote: >> >> Good morning, >> >> Under postgreSQL 8.0, could someone tell me how to pg_dump more than one >> tables at the same time please? >> >> I tried to do something like: >> >> pg_dump -h machineName -U username --inserts --column-inserts >> --file=dump.sql --table=t1 t2 ... ...tN -d databaseName ; > You must specify --table (or -t) once for each of the tables, ie: > pg_dump -h machineName -U username --inserts --column-inserts > --file=dump.sql --table=t1 --table=t2 ..... ..... --table=tN -d databaseName > ; > > -t t1 -t t2 -t t3
I'm pretty sure that the ability to handle multiple -t switches was an 8.2 release feature. See the release notes (search for -t) http://www.postgresql.org/docs/8.3/static/release-8-2.html -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
