Mega Code Archive

 

Categories / Python Tutorial / Database

 

Fetch row one by one

import psycopg dbh = psycopg.connect('dbname=dbname user=username') print "Connection successful." cur = dbh.cursor() cur.execute("SELECT * FROM myTable") cur.arraysize = 2 while 1:     row = cur.fetchone()     if row is None:         break     print row      dbh.close()