如何从 psycopg2 游标获取列名列表? [英] How do I get a list of column names from a psycopg2 cursor?

问题描述

我想要一种直接从所选列名生成列标签的通用方法，并记得看到 python 的 psycopg2 模块支持此功能.

I would like a general way to generate column labels directly from the selected column names, and recall seeing that python's psycopg2 module supports this feature.

推荐答案

来自 Mark Lutz 的Programming Python":

From "Programming Python" by Mark Lutz:

curs.execute("Select * FROM people LIMIT 0")
colnames = [desc[0] for desc in curs.description]

这篇关于如何从 psycopg2 游标获取列名列表?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！