python导出postgresql中的一个表到本地csv表格

 

代码如下 修改xxx即可：

conn = psycopg2.connect(host=DB_SERVICES, user=DB_USERNAME,password=DB_PWD, database=DB_NAME)
cur = conn.cursor(cursor_factory=psycopg2.extras.DictCursor)
sql = f"select * from xxx.xxx"
cur.execute(sql)
res = cur.fetchall()
pandas.DataFrame([dict(item) for item in res]).to_csv("xxx.csv",index=False,encoding="utf-8")