On Mon, Oct 28, 2013 at 4:06 PM, Perry Smith <pedz...@gmail.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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
