psycopg2操作pg库时fetchone的返回值数据类型问题
示例:
import psycopg2
import psycopg2.extras
conn = psycopg2.connect(database="database", user="postgres", password="postgres", host="10.255.175.xxx", port="5432")
(1)cur = conn.cursor()
# 默认的获取游标当cur.fetchone()后返回值为元组;
(2)cur = conn.cursor(cursor_factory=psycopg2.extras.DictCursor)
# 设置DictCursor参数后获取游标则当cur.fetchone()后返回值为列表;
(3)cur = conn.cursor(cursor_factory=psycopg2.extras.RealDictCursor)
# 设置RealDictCursor参数后获取游标则当cur.fetchone()后返回值为字典