Re: pg_dump question

Andreas Kretschmer wrote:
> Alvaro Herrera <alvherre@commandprompt.com> schrieb:
> > > > 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.
>
> Yes, of course. Ref. integrity, for instance. But i don't know, how 8.2
> solve this problem. Can you explain this?

It dumps all tables in a single SERIALIZABLE transaction.

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