Re: Out of memry with large result set - Mailing list pgsql-general

On Mon, Jul 14, 2008 at 11:53 PM, olivier.scalbert@algosyn.com
<olivier.scalbert@algosyn.com> 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;