import psycopg

conn = psycopg.connect(
    host="localhost",
    port=5432,
    user="app",
    password="secret",
    dbname="app",
)
try:
    cur = conn.cursor()

    # Check the server version
    cur.execute("SELECT version()")
    for row in cur.fetchall():
        print(row)

    conn.commit()
finally:
    conn.close()