import psycopg2

# Vytvoreni pripojeni do database
conn = psycopg2.connect(
    dbname="your_database",
    user="your_username",
    password="your_password",
    host="your_host"
)
# Vytvoreni cursoru
cur = conn.cursor()
# Zavolani SELECTu
cur.execute("SELECT * FROM table")
#cur.execute("SELECT * FROM table WHERE id = %s", "1")
rows = cur.fetchall()
# Vytiskneme vsechny vracene radky
for row in rows:
    print(row)
# Zavreni cursoru and pripojeni do databaze
cur.close()
conn.close()