使用Python将嵌套的JSON数据发送到Postgres -无法找到在使用psycopg2的表上插入空值的方法

import psycopg2
import json

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

cur = conn.cursor()

json_data = {
    "key1": "value1",
    "key2": "value2",
    "nested_data": {
        "nested_key1": "nested_value1",
        "nested_key2": "nested_value2"
    }
}

json_str = json.dumps(json_data)

insert_query = "INSERT INTO your_table (json_column) VALUES (%s)"
cur.execute(insert_query, (json_str,))

conn.commit()
cur.close()
conn.close()