Stephen Frost <[EMAIL PROTECTED]> writes: > ... If libpq grabs the entire result in one go then that may > actually cause a problem for me when I start to move things from Oracle > to postgres since the clients don't always have much memory available.
It does that in an ordinary SELECT. The customary answer to this has been "use a cursor and FETCH the number of rows you want to process at a time". regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html