使用python将json数据插入到postgresql表中

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()

with open('your_json_file.json') as file:
    json_data = json.load(file)

for item in json_data:
    json_str = json.dumps(item)
    cur.execute("INSERT INTO your_table_name (column_name) VALUES (%s)", (json_str,))

conn.commit()
conn.close()