Re: pg_dump question

Alvaro Herrera <alvherre(at)commandprompt(dot)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?

Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknow)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°