如何将Select * Postgres/Redshift查询结果放入字典(列/值)

import psycopg2

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

# 创建游标
cur = conn.cursor(cursor_factory=psycopg2.extras.RealDictCursor)

# 执行查询语句
cur.execute("SELECT * FROM your_table")

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

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

# 打印查询结果
for row in results:
    print(row)