将python列表插入Postgres数据库

import psycopg2

# 连接到PostgreSQL数据库
conn = psycopg2.connect(database="your_database", user="your_username", password="your_password", host="your_host", port="your_port")
cur = conn.cursor()

# 创建一个包含Python列表的字符串
python_list = [1, 2, 3, 4, 5]
insert_query = "INSERT INTO your_table (column_name, value) VALUES (%s, %s)"

# 使用psycopg2执行插入操作
cur.execute(insert_query, (python_list,))

# 提交更改
conn.commit()

# 关闭连接
cur.close()
conn.close()