python3 psycopg2查询PostgreSQL返回字典列表。

import psycopg2
from psycopg2 import extras  # 不能少

conn = psycopg2.connect(database="db_name", user="postgres", password="123456", host="localhost", port="5432")
cur = conn.cursor(cursor_factory=psycopg2.extras.DictCursor)  # 字典形式返回游标

cur.execute("SELECT * from news LIMIT 10")
rows = cur.fetchall()
for row in rows:
    print(row['title'])
    print(type(row))
conn.close()

psycopg2.extras.RealDictCursor不支持整型索引，
如果想用整型索引，就要用psycopg2.extras.DictCursor。

参考：
https://www.psycopg.org/docs/extras.html