Re: Cursor Example Needed
От
Merlin Moncure
Тема
Re: Cursor Example Needed
Дата
Msg-id
CAHyXU0zwXsVwK9XVyfsEPmD+vPH-0Fo32j+diFf83HWUupvB-g@mail.gmail.com
Ответ на
Cursor Example Needed (Perry Smith)
Список
Дерево обсуждения
Cursor Example Needed Perry Smith <pedzsan@gmail.com>
Re: Cursor Example Needed Merlin Moncure <mmoncure@gmail.com>
Re: Cursor Example Needed Perry Smith <pedzsan@gmail.com>
Re: Cursor Example Needed Adrian Klaver <adrian.klaver@gmail.com>
Re: Cursor Example Needed Perry Smith <pedzsan@gmail.com>
Re: Cursor Example Needed Adrian Klaver <adrian.klaver@gmail.com>
Re: Cursor Example Needed John R Pierce <pierce@hogranch.com>
Re: Cursor Example Needed Perry Smith <pedzsan@gmail.com>
Re: Cursor Example Needed Adrian Klaver <adrian.klaver@gmail.com>
Re: Cursor Example Needed Perry Smith <pedzsan@gmail.com>
Re: Cursor Example Needed Merlin Moncure <mmoncure@gmail.com>
On Mon, Oct 28, 2013 at 4:06 PM, Perry Smith 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
В списке pgsql-general по дате отправления
