使用Python将结果复制到Postgres

Question

我正在尝试创建一个python脚本，将glob结果复制到postgres中。这就是我所拥有的：

import psycopg2, glob

sitesizetemp = glob.glob('C:/Data/Sheltered BLPUs/CSVs/sitesize*.csv')

conn = psycopg2.connect("dbname=postgres user=postgres")

cur = conn.cursor()

{cd5}

conn.commit()

cur.close()

conn.close()

我对这一切都很陌生，所以任何帮助都是非常欢迎的！谢谢

Answer 1

import psycopg2, glob

sitesizetemp = glob.glob('C:/Data/Sheltered BLPUs/CSVs/sitesize*.csv')
conn = psycopg2.connect("dbname=postgres user=postgres")
cur = conn.cursor()

for f in sitesizetemp:
    cur.execute("COPY sitesize FROM '%s' DELIMITER ',' CSV;" % f)

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