如何使用python将多个CSV文件导入到PostgreSQL表中？

import os
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, ...)")

folder_path = "csv_files"
for file_name in os.listdir(folder_path):
    if file_name.endswith(".csv"):
        file_path = os.path.join(folder_path, file_name)
        with open(file_path, '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()
cur.close()
conn.close()

pip install psycopg2