psycopg2 and large queries

Laszlo Nagy gandalf at shopzeus.com
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!

   Laszlo




More information about the Python-list mailing list