使用Python中的数据库数组创建有效的JSON

import json
import psycopg2

conn = psycopg2.connect(database="your_database", user="your_username", password="your_password", host="your_host", port="your_port")

cur = conn.cursor()

cur.execute("SELECT * FROM your_table")

rows = cur.fetchall()

data = []
for row in rows:
    item = {
        'column1': row[0],
        'column2': row[1],
        'column3': row[2]
    }
    data.append(item)

json_data = json.dumps(data)