使用python psycopg2在PostgreSQL数据库中插入嵌套json数据(某些键不存在)时出现问题

import psycopg2

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

cur = conn.cursor()

json_data = {
    "key1": "value1",
    "key2": "value2",
    "key3": {
        "nested_key1": "nested_value1",
        "nested_key2": "nested_value2"
    },
    "key4": "value4"
}

jsonb_data = psycopg2.extras.Json(json_data, dumps=lambda obj: json.dumps(obj, ensure_ascii=False))

cur.execute("INSERT INTO your_table (jsonb_column) VALUES (%s)", (jsonb_data,))

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