Pandas(DataFrame)最简单最快速导入Postgresql

import psycopg2
def output(data):
    from io import StringIO
    # 连接数据库
    data = 
    conn = psycopg2.connect(database='xxx', user='username', password='password', host='xxxx', port='5432')

    # dataframe类型转换为IO缓冲区中的str类型
    output = StringIO()
    data[['user_id','tag_recall']].to_csv(output, sep='\t', index=False, header=False)
    output1 = output.getvalue()

    cur = conn.cursor()
    cur.copy_from(StringIO(output1), "xxx目标表")
    conn.commit()
    cur.close()
    conn.close()
    print('finish!!!!')
    return True