import pyodbc print pyodbc.version con_pq = pyodbc.connect('DRIVER={PostgreSQL Unicode};SERVER=146.156.114.11;PORT=5432;DATABASE=databasename;USERNAME=admin_login;PASSWORD=passwordwithnums34') # Open a cursor to perform database operations c_pq = con_pq.cursor() r = c_pq.execute("""select 5""") for i in r: print i #con_pq.commit() c_pq.close() con_pq.close()