Naomi Walker wrote: > Can we add unload/load functionality to the list, please? > > > > > > >Yes, agreed, it would be nice to have WHERE as part of COPY. In fact, I > > > >like Informix's solution, which merges data in/out with INSERT/SELECT: > > > > > > > > UNLOAD TO '/tmp/x' > > > > SELECT * > > > > FROM tab; > > > > > > > >and > > > > > > > > LOAD FROM '/tmp/x' > > > > INSERT INTO tab;
I have thought of that. We would probably join COPY to INSERT/SELECT rather than use LOAD/UNLOAD. The problem is that the COPY code reads right out of the table, rather than reading from the executor. This change would require that. You can do it now by using TEMP tables to do the 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 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly