Re: pg_dump more than one table in one command? - Mailing list pgsql-sql
| From | Harold A. Giménez Ch. |
|---|---|
| Subject | Re: pg_dump more than one table in one command? |
| Date | |
| Msg-id | [email protected] Whole thread Raw |
| In response to | Re: pg_dump more than one table in one command? ("Scott Marlowe" <[email protected]>) |
| List | pgsql-sql |
<div dir="ltr">Looks like you are right, Scott. Thanks! I wasn't in Postgres land back then.<br /><br /><div class="gmail_quote">OnMon, Oct 6, 2008 at 5:48 PM, Scott Marlowe <span dir="ltr"><<a href="mailto:[email protected]">[email protected]</a>></span>wrote:<br /><blockquote class="gmail_quote" style="border-left:1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="Ih2E3d">On Mon,Oct 6, 2008 at 3:24 PM, Harold A. Giménez Ch.<br /> <<a href="mailto:[email protected]">[email protected]</a>>wrote:<br /> ><br /> > On Mon, Oct 6, 2008 at5:02 PM, Emi Lu <<a href="mailto:[email protected]">[email protected]</a>> wrote:<br /> >><br />>> Good morning,<br /> >><br /> >> Under postgreSQL 8.0, could someone tell me how to pg_dump more thanone<br /> >> tables at the same time please?<br /> >><br /> >> I tried to do something like:<br />>><br /> >> pg_dump -h machineName -U username --inserts --column-inserts<br /> >> --file=dump.sql --table=t1t2 ... ...tN -d databaseName ;<br /> > You must specify --table (or -t) once for each of the tables, ie:<br/> > pg_dump -h machineName -U username --inserts --column-inserts<br /> > --file=dump.sql --table=t1 --table=t2..... ..... --table=tN -d databaseName<br /> > ;<br /> ><br /> > -t t1 -t t2 -t t3<br /><br /></div>I'mpretty sure that the ability to handle multiple -t switches was an<br /> 8.2 release feature. See the releasenotes (search for -t)<br /><br /><a href="http://www.postgresql.org/docs/8.3/static/release-8-2.html" target="_blank">http://www.postgresql.org/docs/8.3/static/release-8-2.html</a><br/></blockquote></div><br /></div>