pip install psycopg2
pip3 install psycopg2
python
import psycopg2
conn = psycopg2.connect(
host="localhost",
database="mydatabase",
user="myuser",
password="mypassword"
)
python
cursor = conn.cursor()
sql_query = "SELECT * FROM mytable"
cursor.execute(sql_query)
results = cursor.fetchall()
for row in results:
print(row)
python
import os
import psycopg2
host = os.environ.get("POSTGRESQL_HOST")
database = os.environ.get("POSTGRESQL_DATABASE")
user = os.environ.get("POSTGRESQL_USER")
password = os.environ.get("POSTGRESQL_PASSWORD")
conn = psycopg2.connect(
host=host,
database=database,
user=user,
password=password
)
