在带有请求和psycopg2的Postgres中插入Json

pip install requests
pip install psycopg2

import requests
import psycopg2

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

cur = conn.cursor()

json_data = {
    "key1": "value1",
    "key2": "value2",
    "key3": "value3"
}

json_str = json.dumps(json_data)

sql = "INSERT INTO your_table (json_column) VALUES (%s)"

cur.execute(sql, (json_str,))
conn.commit()

cur.close()
conn.close()