psycopg2 and large queries

Laszlo Nagy gandalf at
Fri Dec 19 08:54:26 CET 2008

> They do have a description attribute, but it is only populated after
> you fetch a row.  eg try
> cur = conn.cursor(name='mycursor')
> cur.execute('select name from blah')
> cur.fetchone()
> print cur.description
Oh, great. I should have known. Thanks. Maybe I can live with psycopg2, 
because combining server side (named) cursors with fetchmany(100) gives 
fast query opening and relatively fast row fetching.

Thank you for all!


More information about the Python-list mailing list