Skip site navigation (1) Skip section navigation (2)

Re: pg_dump more than one table in one command?

From: Harold A(dot) Giménez Ch(dot) <harold(dot)gimenez(at)gmail(dot)com>
To: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
Cc: emilu(at)encs(dot)concordia(dot)ca, pgsql-sql(at)postgresql(dot)org
Subject: Re: pg_dump more than one table in one command?
Date: 2008-10-06 21:52:09
Message-ID: c807ef1a0810061452s1a56347av490c95eabe370ffa@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-sql
Looks like you are right, Scott. Thanks! I wasn't in Postgres land back
then.

On Mon, Oct 6, 2008 at 5:48 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>wrote:

> On Mon, Oct 6, 2008 at 3:24 PM, Harold A. Giménez Ch.
> <harold(dot)gimenez(at)gmail(dot)com> wrote:
> >
> > 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 ;
> > 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
>

In response to

pgsql-sql by date

Next:From: Erik JonesDate: 2008-10-07 07:27:55
Subject: Array from INSERT .. RETURNING in plpgsql?
Previous:From: Scott MarloweDate: 2008-10-06 21:48:06
Subject: Re: pg_dump more than one table in one command?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group