Query a PostgreSQL database from Python. Further information at https://code.adonline.id.au/query-a-postgresql-database-via-python/

sql_query.py

#!/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)