作者:shirliyap | 来源:互联网 | 2022-12-10 13:53
1> Maurice Meye..:
我认为您想要RealDictCursor
,这将每行作为dict返回,您无需修改SQL查询:
from psycopg2.extras import RealDictCursor
cur = conn.cursor(cursor_factory=RealDictCursor)
query_sql = "SELECT id, name FROM products where id <10"
cur.execute(query_sql)
results = cur.fetchall()
print(results)
返回值:
[{'id': 2L, 'name': 'Foo'}, {'id': 4L, 'name': 'Bar'}, ...]