postgres 数据库查询数据返回字典格式

最新推荐文章于 2024-07-10 00:11:58 发布

码农-Python高工

最新推荐文章于 2024-07-10 00:11:58 发布

阅读量1.6k

点赞数

分类专栏：数据库

本文链接：https://blog.csdn.net/weixin_44541001/article/details/104651324

版权

数据库专栏收录该内容

19 篇文章 0 订阅

订阅专栏

import psycopg2
import psycopg2.extras
db = {
    'host': '127.0.0.1',
    'port': 5432,
    'database': 'postgres',
    'user': 'postgres',
    'password': 'postgres',
}

conn = psycopg2.connect(**db)
cur = conn.cursor(cursor_factory=psycopg2.extras.RealDictCursor)
sql = """select * from test"""
cur.execute(sql)
data_list = cur.fetchall()
print(data_list)
print(len(data_list))


"""
[RealDictRow([('id', 1), ('name', '1'), ('parent_id', 1), ('level', 1), ('lat', '1'), ('lng', '1'), ('group_id', None), ('data', None), ('x_min', None), ('x_max', None), ('y_min', None), ('y_max', None)]), RealDictRow([('id', 2), ('name', '2'), ('parent_id', 2), ('level', 2), ('lat', '2'), ('lng', '2'), ('group_id', None), ('data', None), ('x_min', None), ('x_max', None), ('y_min', None), ('y_max', None)]), RealDictRow([('id', 3), ('name', '3'), ('parent_id', 3), ('level', 3), ('lat', '3'), ('lng', '3'), ('group_id', None), ('data', None), ('x_min', None), ('x_max', None), ('y_min', None), ('y_max', None)]), RealDictRow([('id', 4), ('name', '4'), ('parent_id', 4), ('level', 4), ('lat', '4'), ('lng', '4'), ('group_id', None), ('data', None), ('x_min', None), ('x_max', None), ('y_min', None), ('y_max', None)])]
4
"""