我想在Flask上将Postgres Table导出为CSV文件作为下载按钮。如何做到这一点？

@app.route('/export-csv', methods=['GET'])
def export_csv():
    # 代码逻辑将在这里实现
    pass

import csv
import psycopg2

@app.route('/export-csv', methods=['GET'])
def export_csv():
    conn = psycopg2.connect(database="your_database", user="your_username", password="your_password", host="your_host", port="your_port")
    cursor = conn.cursor()

    # 执行查询语句，获取需要导出的数据
    cursor.execute("SELECT * FROM your_table")

    # 获取查询结果
    results = cursor.fetchall()

    # 关闭数据库连接
    cursor.close()
    conn.close()

import csv
import psycopg2

@app.route('/export-csv', methods=['GET'])
def export_csv():
    conn = psycopg2.connect(database="your_database", user="your_username", password="your_password", host="your_host", port="your_port")
    cursor = conn.cursor()

    # 执行查询语句，获取需要导出的数据
    cursor.execute("SELECT * FROM your_table")

    # 获取查询结果
    results = cursor.fetchall()

    # 关闭数据库连接
    cursor.close()
    conn.close()

    # 创建CSV文件并写入数据
    with open('data.csv', 'w', newline='') as csvfile:
        writer = csv.writer(csvfile)
        writer.writerows(results)

from flask import send_file

@app.route('/export-csv', methods=['GET'])
def export_csv():
    # ...上述代码省略

    # 创建CSV文件并写入数据
    with open('data.csv', 'w', newline='') as csvfile:
        writer = csv.writer(csvfile)
        writer.writerows(results)

    # 发送CSV文件供用户下载
    return send_file('data.csv', as_attachment=True, attachment_filename='data.csv')