On Oct 28, 2013, at 4:11 PM, Merlin Moncure <mmoncure@xxxxxxxxx> wrote: > On Mon, Oct 28, 2013 at 4:06 PM, Perry Smith <pedzsan@xxxxxxxxx> wrote: >> When I execute the SELECT statement directly I get: >> >> psql:table.sql:28: out of memory for query result > > psql will do this automatically if you tell it to: > http://doginpool.blogspot.com/2011/11/retrieving-large-resultsets-from.html > > cursors can work with your code, but they need participation from the > client side. basically you stage the cursor then repeatedly FETCH > until done. Ok. I'll try that. I'm still curious how to do it using cursors if anyone wants to provide a sample. Thank you, Perry
Attachment:
signature.asc
Description: Message signed with OpenPGP using GPGMail
