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