带有datetime64数据类型的数据帧插入到postgressql时间戳列

import psycopg2
import pandas as pd

# 连接到PostgreSQL数据库
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 your_table (timestamp_col timestamp, other_col1 varchar, other_col2 int)")

# 转换datetime64数据类型
df['timestamp_col'] = df['timestamp_col'].dt.to_pydatetime()

# 插入数据
for index, row in df.iterrows():
    timestamp = row['timestamp_col'].strftime('%Y-%m-%d %H:%M:%S')
    other_col1 = row['other_col1']
    other_col2 = row['other_col2']
    cur.execute("INSERT INTO your_table (timestamp_col, other_col1, other_col2) VALUES (%s, %s, %s)", (timestamp, other_col1, other_col2))

# 提交事务并关闭连接
conn.commit()
cur.close()
conn.close()