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 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 ; > > Thanks a lot! > > -- > Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-sql >