我已经更新了代码，以创建一个包含所有索引文件列表的文本文件。这将允许代码只读取看不见的csv文件。

import os
import psycopg2

dir_name = 'C:/john/database_files'
processed_files = []

# Load processed_files from a file, if it exists
try:
    with open('processed_files.txt', 'r') as f:
        processed_files = f.read().splitlines()
except FileNotFoundError:
    pass

con = psycopg2.connect(database="xxxx", user="xxxx", password="xxxx", host="xxxx")

# Loop over all CSV files in the directory
for file_name in os.listdir(dir_name):
    if file_name.endswith('.csv') and file_name not in processed_files:
        with open(os.path.join(dir_name, file_name), 'r') as file_in:
            next(file_in)
            with con.cursor() as cur:
                cur.copy_from(file_in, "table_name", columns=('col1', 'col2', 'col3', 'col4', 'col5'), sep=",")
            con.commit()

        # Mark this file as processed
        processed_files.append(file_name)

con.close()

# Save the list of processed files
with open('processed_files.txt', 'w') as f:
    for file_name in processed_files:
        f.write("%s\n" % file_name)

字符串