Re: [GENERAL] dumping 8M bit fields

2006-09-22 Thread Jeff Davis
On Thu, 2006-09-21 at 20:14 -0400, Rajarshi Guha wrote: > Hi, I have a table with 8M rows and one of the fields is a bit (1024 > bits) field. I am trying to dump the bit field for 8M rows to a file: > > psql -U cicc3 -A -F " " -t -o pubchem.fp -c "select cid,gfp from > pubchem_compound; > > Howev

Re: [GENERAL] dumping 8M bit fields

2006-09-22 Thread Martijn van Oosterhout
On Thu, Sep 21, 2006 at 08:14:49PM -0400, Rajarshi Guha wrote: > Hi, I have a table with 8M rows and one of the fields is a bit (1024 > bits) field. I am trying to dump the bit field for 8M rows to a file: > out of memory for query result > > I am surprised since I did an equivalent query but se