A simple example of using Postgres in Python

example_postgres.py

import psycopg2

# make a connection
try:
    conn = psycopg2.connect(database='postgres', user='postgres', password='economicalchinchillacorndog', host='localhost')
    cur = conn.cursor()
except:
    print('Database Connection Failed')
    raise

# run a SQL query
cur.execute('SELECT * FROM orders')

# iterate through the results
for item in cur.fetchall():
    print(item)