> > FWIW, there's a feature in CVS HEAD to instruct psql to try to use a > > cursor to break up huge query results like this. For the moment I'd > > suggest using COPY instead. > > > That's sort of what I was afraid off. I am trying to get 100 million > records into a text file in a specific order. > > Sigh, I have to write a quick program to use a cursor. :-(
Why don't you try the psql client from 8.2beta1 then? This way you don't have to write the program yourself and you're helping out with beta testing as well :-) See FETCH_COUNT in http://developer.postgresql.org/pgdocs/postgres/app-psql.html Bye, Chris. ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org