测试postgres db python

import psycopg2

conn = psycopg2.connect(
    host="localhost",
    database="mydatabase",
    user="myuser",
    password="mypassword"
)

cur = conn.cursor()
cur.execute("""
    CREATE TABLE users (
        id SERIAL PRIMARY KEY,
        name VARCHAR(100),
        email VARCHAR(100)
    )
""")
conn.commit()

cur = conn.cursor()
cur.execute("""
    INSERT INTO users (name, email)
    VALUES (%s, %s)
""", ("John Doe", "john@example.com"))
conn.commit()

cur = conn.cursor()
cur.execute("SELECT * FROM users")
rows = cur.fetchall()

for row in rows:
    print(row)

cur = conn.cursor()
cur.execute("""
    UPDATE users
    SET email = %s
    WHERE id = %s
""", ("newemail@example.com", 1))
conn.commit()

cur = conn.cursor()
cur.execute("DELETE FROM users WHERE id = %s", (1,))
conn.commit()