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 [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
