Getting column names from a cursor using ODBC module?
cwitts at gmail.com
Sat Jun 21 22:52:48 CEST 2008
On Jun 21, 3:58 pm, dana... at yahoo.com wrote:
> Is there any way to retrieve column names from a cursor using the ODBC
> module? Or must I, in advance, create a dictionary of column position
> and column names for a particular table before I can access column
> values by column names? I'd prefer sticking with the ODBC module for
> now because it comes standard in Python.
> I'm using Python 2.4 at the moment.
You should be able to do
column_names = [d for d in cursor.description]
More information about the Python-list