Skip to content

Instantly share code, notes, and snippets.

@AdamDimech

AdamDimech/sql_query.py

Last active Dec 11, 2020
Embed
What would you like to do?
Query a PostgreSQL database from Python. Further information at https://code.adonline.id.au/query-a-postgresql-database-via-python/
#!/usr/bin/env python
import psycopg2
try:
login = "dbname='YourDatabaseName' user='Adam' host='127.0.0.1' " + \
"password='MyPa$$word'"
# Establish a connection
conn = psycopg2.connect(login)
# Create a psycopg2 cursor that can execute queries
cursor = conn.cursor()
# Run a query
cursor.execute("""SELECT * from table""")
rows = cursor.fetchall()
print(rows)
cursor.close()
conn.close()
except Exception as e:
print("Unable to connect to database")
print(e)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment