pyodbc

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()