Getting column names from a cursor using ODBC module?

Chris cwitts at
Sat Jun 21 16:52:48 EDT 2008

On Jun 21, 3:58 pm, dana... at 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