Python gets postgres query result can have column name

1 ImportPSYCOPG22 ImportPsycopg2.extras3 4conn = Psycopg2.connect (Database=self.dbname, User=self.username, Password=self.password, Host=self.host, port=self.port)5cursor = Self.conn.cursor (cursor_factory=psycopg2.extras.DictCursor)6sql =""7 cursor.execute (SQL)8rows =Self.cursor.fetchall ()9 #The elements in the rows at this point are the structure of the rowdict type,Ten  forRowinchrows: One     Printrow['a column name'] Access

Reference: Http://yuanjun.me/postgresql/pythoncao-zuo-postgresql#toc_5

When you need to initialize the cursor in the case of a query result column name, you need to pay special attention to adding

Cursor_factory=psycopg2.extras.dictcursor

So it does not affect the normal traversal of access, such as

# a,b,c,d are specific query values

Python gets postgres query result can have column name