On Mon, Jul 14, 2008 at 11:53 PM, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > >> Try copy (query) to stdout. >> >> For me, psql sits at 4.9mb ram on a 3x10^16 row query. >> >> klint. >> > > Thanks Klint. > Can I use a 'copy to' for a query ? I thought I can only do 'copy > table to stdout' > I will do some tests tomorrow and keep you inform.
In 8.2.9 this works: copy (select * from mytable) to stdout; -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
