通过python将json数据传输到postgres

import json
import psycopg2

def convert_json_to_dict(json_data):
    data_dict = json.loads(json_data)
    return data_dict

def insert_data_to_postgres(data_dict):
    conn = psycopg2.connect(database="your_database", user="your_username", password="your_password", host="your_host", port="your_port")
    cursor = conn.cursor()
    
    # 根据需要修改以下代码，将数据插入到指定的表中
    cursor.execute("INSERT INTO your_table (column1, column2) VALUES (%s, %s)", (data_dict['key1'], data_dict['key2']))
    
    conn.commit()
    conn.close()

json_data = '{"key1": "value1", "key2": "value2"}'
data_dict = convert_json_to_dict(json_data)
insert_data_to_postgres(data_dict)