How to get field names when running plain sql query in django

Question

In one of my django views I query database using plain sql (not orm) and return results.

sql = "select * from foo_bar"
cursor = connection.cursor()
cursor.execute(sql)
rows = cursor.fetchall()

I am getting the data fine, but not the column names. How can I get the field names of the result set that is returned?

Answer 1

According to PEP 249, you can try using cursor.description, but this is not entirely reliable.