Re: Out of memry with large result set

["Scott Marlowe" <scott.marlowe@xxxxxxxxx>]

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