Getting column names from a cursor using ODBC module?

Chris 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.
>
> Thanks.

You should be able to do

column_names = [d[0] for d in cursor.description]



More information about the Python-list mailing list