def todb(df, tablename, columns=None):
'''
df:dataframe
tablename: 表名
columns: 列名(dataframe如完全按照表字段 可不写)
'''
strio = StringIO()
df.to_csv(strio, sep='\t', index=False, header=False)
output = strio.getvalue()
conn = psycopg2.connect(database="XXX", user="XXX", password="XXX", host="XXX")
cur = conn.cursor()
cur.copy_from(StringIO(output), tablename, columns=columns)
conn.commit()
cur.close()
conn.close()
strio.close()