Re: db partial dumping with pg_dump

Hannu Krosing wrote:
> On Wed, 2002-08-14 at 00:03, Bruce Momjian wrote:
> >
> > Actually, loading all this stuff into COPY is not the way to go, I
> > think.
> >
> > Informix had:
> >
> > UNLOAD TO 'filename'
> > SELECT ...
> >
> > I have to admit, this is a superior way to do thing compared to what we
> > have. Is is possible for us to get:
> >
> > COPY TO 'filename'
> > SELECT ...
> >
> > It allows any arbitrary table, group by, even order by combination.
>
>
> It would be more in line with the rest of the system to just allow
> subselect as 'table'
>
> COPY (select in,name from mystuff wher id > 10) over10stuff TO stdout;

Yep, that would work too. Clearly, we should shoot for something that
leverages the existing SELECT code rather than hang more clauses off of
COPY.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073