[D]psycopg2有没有dictfetchall方法

[坚强的豁着]

今天用了一下，提示这个

<type 'exceptions.AttributeError'>: 'psycopg2._psycopg.cursor' object has no attribute 'dictfetchall'
args = ("'psycopg2._psycopg.cursor' object has no attribute 'dictfetchall'",)
message = "'psycopg2._psycopg.cursor' object has no attribute 'dictfetchall'"

在网上找了半天没有这方面的资料，请高手求救

---------------------
Double行动：
原帖分数：40
帖子加分：40

[bugs2k]

>>> cur.execute("SELECT * FROM test;")
>>> cur.fetchall()
[(1, 100, "abc'def"), (2, None, 'dada'), (3, 42, 'bar')]

>>> dict_cur = conn.cursor(cursor_factory=psycopg2.extras.DictCursor)
>>> dict_cur.execute("INSERT INTO test (num, data) VALUES(%s, %s)",
...                  (100, "abc'def"))
>>> dict_cur.execute("SELECT * FROM test")
>>> rec = dict_cur.fetchone()
>>> rec['id']
1
>>> rec['num']
100
>>> rec['data']
"abc'def"

[坚强的豁着]

[Quote=引用 1 楼 的回复:]

Python code
>>> cur.execute("SELECT * FROM test;")
>>> cur.fetchall()
[(1, 100, "abc'def"), (2, None, 'dada'), (3, 42, 'bar')]

Python code

>>> dict_cur = conn.cursor(cursor_factory=psycopg2.extr……
[/Quote]
我要结果确实是一个字典，我用

names=[d[0] for d in curs.description]
rows=[dict(zip(names,row)) for row in curs.fetchall()]

代替可否？

[bugs2k]

psycopg2.extras.DictCursor

[Quote=引用 2 楼 的回复:]

引用 1 楼 的回复:

Python code
>>> cur.execute("SELECT * FROM test;")
>>> cur.fetchall()
[(1, 100, "abc'def"), (2, None, 'dada'), (3, 42, 'bar')]

Python code

>>> dict_cur = conn.cursor(cursor_f……
[/Quote]

[坚强的豁着]

AttributeError: 'module' object has no attribute 'extras'

没理解您的意思