如何在Python Flask应用程序中使用游标响应列名？

from flask import Flask, jsonify
import psycopg2

app = Flask(__name__)

conn = psycopg2.connect(database="your_database", user="your_username", password="your_password", host="your_host", port="your_port")
cur = conn.cursor()

cur.execute("SELECT * FROM your_table")
rows = cur.fetchall()

column_names = [desc[0] for desc in cur.description]

results = []
for row in rows:
    results.append(dict(zip(column_names, row)))

cur.close()
conn.close()

@app.route('/data', methods=['GET'])
def get_data():
    return jsonify(results)

from flask import Flask, jsonify
import psycopg2

app = Flask(__name__)

@app.route('/data', methods=['GET'])
def get_data():
    conn = psycopg2.connect(database="your_database", user="your_username", password="your_password", host="your_host", port="your_port")
    cur = conn.cursor()
    cur.execute("SELECT * FROM users")
    rows = cur.fetchall()
    column_names = [desc[0] for desc in cur.description]
    results = []
    for row in rows:
        results.append(dict(zip(column_names, row)))
    cur.close()
    conn.close()
    return jsonify(results)

if __name__ == '__main__':
    app.run()