python
import psycopg2
conn = psycopg2.connect(database="mydb", host="localhost", port="5432")
cur = conn.cursor()
cur.execute("CREATE TABLE users (id SERIAL PRIMARY KEY, name VARCHAR(50), age INTEGER)")
cur.execute("INSERT INTO users (name, age) VALUES (%s, %s)", ("Alice", 28))
cur.execute("INSERT INTO users (name, age) VALUES (%s, %s)", ("Bob", 32))
cur.execute("INSERT INTO users (name, age) VALUES (%s, %s)", ("Charlie", 25))
conn.commit()
cur.execute("SELECT * FROM users")
rows = cur.fetchall()
for row in rows:
print("Id:", row[0])
print("Name:", row[1])
print("Age:", row[2])
cur.close()
conn.close()