From: | Harold A(dot) Giménez Ch(dot) <harold(dot)gimenez(at)gmail(dot)com> |
---|---|
To: | emilu(at)encs(dot)concordia(dot)ca |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: pg_dump more than one table in one command? |
Date: | 2008-10-06 21:24:17 |
Message-ID: | c807ef1a0810061424s148345e4s878c437dc78e0c1d@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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 <emilu(at)encs(dot)concordia(dot)ca> 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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2008-10-06 21:48:06 | Re: pg_dump more than one table in one command? |
Previous Message | Emi Lu | 2008-10-06 21:02:50 | pg_dump more than one table in one command? |