On Mon, Oct 28, 2013 at 4:06 PM, Perry Smith <pedzsan(at)gmail(dot)com> 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.
merlin