Database Python Tutorial

  1. Home
  2. Python Tutorial
  3. Database
  4. Get cursor
import psycopg
dbh = psycopg.connect('dbname=dbname user=username')
print "Connection successful."
cur = dbh.cursor()
cur.execute("SELECT * FROM myTable")
cur.fetchone()
    
print "Obtained %d rows" % cur.rowcount
dbh.close()