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@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073