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