如何使用python将csv数据导入postgres数据库

import csv
import psycopg2

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

cur = conn.cursor()

cur.execute("CREATE TABLE IF NOT EXISTS your_table (column1 datatype1, column2 datatype2, ...)")

with open('your_csv_file.csv', 'r') as file:
    reader = csv.reader(file)
    next(reader)  # 跳过标题行
    for row in reader:
        # 将每一行数据插入到表格中
        cur.execute("INSERT INTO your_table (column1, column2, ...) VALUES (%s, %s, ...)", row)

conn.commit()
conn.close()