Re: pg_dump question - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: pg_dump question
Date
Msg-id 20061102155608.GE25444@alvh.no-ip.org
Whole thread Raw
In response to Re: pg_dump question  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Responses Re: pg_dump question  (Andreas Kretschmer <akretschmer@spamfence.net>)
Re: pg_dump question  (Ron Johnson <ron.l.johnson@cox.net>)
List pgsql-general
A. Kretschmer wrote:
> am  Wed, dem 01.11.2006, um 13:50:58 -0800 mailte Thomas Burns folgendes:
> > Hi,
> >
> > I would like to use pg_dump to backup a list of tables to one file,
> > but it looks like
> > the -t option only supports one file. So, pg_dump gives you the
> > option of backing
> > up and entire database or one file, but nothing in between.  Am I
> > missing something?
> > Is there a way to backup multiple tables (but not the whole database)?
>
> You can wait for 8.2, this version supports multiple -t - options.
> Or you can concat several table-dumps to one big dump.

Note that the latter option does not guarantee that you get a consistent
dump.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-general by date:

Previous
From: Markus Schiltknecht
Date:
Subject: Re: lots of values for IN() clause
Next
From: Shelby Cain
Date:
Subject: Re: lots of values for IN() clause