- 参考
插入的表名为参数,插入数据为大量数据
from psycopg2.extensions import AsIs
data = []
data.append(
(AsIs(tablename),val1,val2),
(AsIs(tablename),val3,val4)
)
cur.executemany('''insert into \"%s\" values (%s,%s,%s) on conflict do nothing''',data) #如果表存在,则不做处理,退出
- 存入万得示例
from WindPy import w
import psycopg2
w.start()
wdata = w.wsd(...)
data_size = len(wdata.Data[0])
data = []
for i in range(data_size):
data.append(
wdata.Data[0][i],
wdata.Data[1][i],
...
)
conn = psycopg2.connect('user=user dbname=dbname')
cur = conn.cursor()
cur.executemany('''insert into table values(%s,%s,...)''',data)
conn.commit()
conn.close()
w.close()