psycopg2 and large queries

[D'Arcy J.M. Cain]

On Thu, 18 Dec 2008 22:28:23 +0100
Laszlo Nagy <gandalf at shopzeus.com> wrote:
> - PyGresSQL: apparently, it does not support fetching one row, only 
> fetching all rows (see: 
> http://www.pygresql.org/pg.html#getresult-get-query-values-as-list-of-tuples), 
> so this is not an option. (Yes, it also has a db api compilant module, 
> but it is only a wrapper around pgqueryobject, and it does not support 
> server side cursors...)

I'm not sure where you get that.  The DB-API compliant execute function
uses server side cursors with fetch.

-- 
D'Arcy J.M. Cain <darcy at druid.net>         |  Democracy is three wolves
http://www.druid.net/darcy/                |  and a sheep voting on
+1 416 425 1212     (DoD#0082)    (eNTP)   |  what's for dinner.