将数据从postgres保存到文件txt或csv

import psycopg2

# 连接到PostgreSQL数据库
conn = psycopg2.connect(database="your_database", user="your_user", password="your_password", host="your_host", port="your_port")

# 创建一个游标对象
cur = conn.cursor()

# 执行查询语句
cur.execute("SELECT * FROM your_table")

# 获取查询结果
rows = cur.fetchall()

# 将结果保存到文件
with open("output.txt", "w") as file:
    for row in rows:
        line = "\t".join(str(cell) for cell in row)  # 使用制表符分隔每列数据
        file.write(line + "\n")  # 写入文件，并添加换行符

# 关闭游标和数据库连接
cur.close()
conn.close()

import csv
import psycopg2

# 连接到PostgreSQL数据库
conn = psycopg2.connect(database="your_database", user="your_user", password="your_password", host="your_host", port="your_port")

# 创建一个游标对象
cur = conn.cursor()

# 执行查询语句
cur.execute("SELECT * FROM your_table")

# 获取查询结果
rows = cur.fetchall()

# 将结果保存到CSV文件
with open("output.csv", "w", newline="") as file:
    writer = csv.writer(file)
    for row in rows:
        writer.writerow(row)

# 关闭游标和数据库连接
cur.close()
conn.close()