在python中查询多个postgres表

import psycopg2

# 连接到PostgreSQL数据库
conn = psycopg2.connect(
    host="your_host",
    database="your_database",
    user="your_user",
    password="your_password"
)

# 创建一个游标对象
cur = conn.cursor()

# 编写SQL查询语句
sql = "SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id"

# 执行查询
cur.execute(sql)

# 获取查询结果
results = cur.fetchall()

# 处理查询结果
for row in results:
    # 处理每一行数据
    print(row)

# 关闭游标和数据库连接
cur.close()
conn.close()