python 操作 postgreSQL 数据库 Demo ( 基于PyGreSQL 包)

最新推荐文章于 2024-07-27 18:56:22 发布

Sinsa_SI

最新推荐文章于 2024-07-27 18:56:22 发布

阅读量1.7k

点赞数 1

分类专栏：计算机语言集文章标签： postgresql PyGreSQL python

本文链接：https://blog.csdn.net/Sinsa110/article/details/78764857

版权

计算机语言集同时被 3 个专栏收录

26 篇文章 0 订阅

订阅专栏

Python

25 篇文章 2 订阅

订阅专栏

PostgreSQL

2 篇文章 0 订阅

订阅专栏

安装

安装命令 sudo pip install PyGreSQL

NOTE: 可能报如下错误

Traceback (most recent call last):
      File "<string>", line 1, in <module>
      File "/tmp/pip-build-f61ovl/PyGreSQL/setup.py", line 88, in <module>
        pg_version = pg_version()
      File "/tmp/pip-build-f61ovl/PyGreSQL/setup.py", line 82, in pg_version
        match = re.search(r'(\d+)\.(\d+)', pg_config('version'))
      File "/tmp/pip-build-f61ovl/PyGreSQL/setup.py", line 74, in pg_config
        raise Exception("pg_config tool is not available.")
    Exception: pg_config tool is not available.

Command "python setup.py egg_info" failed with error code 1 in /tmp/pip-build-f61ovl/PyGreSQL/

解决办法 sudo apt-get install libpq-dev

使用

见官方文档 www.pygresql.org

DEMO

from pg import DB
db = DB(dbname='test', host='localhost', port=5432, user='user1', passwd='123456')
sql = "select * from test_table limit 10"
q = db.query(sql)
result_list = q.getresult()

NOTE：这里的 SQL 语句是 postgreSQL, 参考 www.postgresql.org