如何使用python将最新的CSV文件导入Postgres？

import os
import glob
import csv
import psycopg2

csv_path = max(glob.iglob('/path/to/csv/files/*.csv'), key=os.path.getctime)

conn = psycopg2.connect(database="your_database", user="your_user", 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(csv_path, 'r') as f:
    reader = csv.reader(f)
    next(reader)  # 跳过标题行（如果有）
    for row in reader:
        cur.execute("INSERT INTO your_table VALUES (%s, %s, ...)", row)

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