How to fetch data from postgres including column name using psycopg2 in python3

Question

I am trying to fetch data from a postgres table using psycopg2. Here is what i have done.

import psycopg2


con = psycopg2.connect("host=localhost dbname=crm_whatsapp user=odoo password=password")
cur = con.cursor()
sql = """SELECT * from tbl_hospital;"""
db_cursor.execute(sql)
hospital_data = db_cursor.fetchall()
print('hospital_data',hospital_data)

And the output is:

hospital_data [(1, 'hospital1', 1), (2, 'hospital2', 2), (3, 'hospital3', 3), (4, 'hospital4', 1)]

The output is not contains the cloumn header. I need that too. How can i get that.?

mikeb · Accepted Answer · 2020-01-21 12:44:59Z

1

The cursor has the metadata in it.

From "Programming Python" by M. Lutz:

...
db_cursor.execute(sql)
colnames = [desc[0] for desc in db_cursor.description]

answered Jan 21, 2020 at 12:44

mikeb

11.5k9 gold badges73 silver badges135 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to fetch data from postgres including column name using psycopg2 in python3

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related