> 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. Olivier