On Sep 18 02:57, David Brain wrote: > >Use COPY instead. (You can also prefer CURSORs in your client > >applications. See related discussions.) > > Yes, but COPY isn't an option if I need to do: > > SELECT * from really_big_table where foo='zebra' order by createddate > > Which is what I really need to do (forgot the where clause in the example). For an alternative to COPY, IMHO you can create and use a CURSOR with some help from shell (e.g. a while loop) to form a "FETCH FORWARD ..." query family. > Any other workarounds? AFAIK, you'll be able to use subselects and views in COPY with 8.2 release. Regards.
