[linux-014] 在ubunut上python3读写greenplum

最新推荐文章于 2023-03-08 17:00:00 发布

未济2019

最新推荐文章于 2023-03-08 17:00:00 发布

阅读量879

点赞数

CC 4.0 BY-SA版权

文章标签： greenplum python3

本文链接：https://blog.youkuaiyun.com/lizhe_dashuju/article/details/98973112

本文介绍如何在Python环境中安装并使用Psycopg2模块连接PostgreSQL数据库，通过具体代码示例展示了设置日志记录、执行SQL查询及处理结果的过程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

sudo apt-get install libpq-dev python-dev
pip3 install Psycopg2

# https://www.cnblogs.com/xiao-apple36/p/10362367.html
# http://initd.org/psycopg/docs/
# sudo apt-get install libpq-dev python-dev
# Psycopg2

import psycopg2
import psycopg2.extensions
import logging

class LoggingCursor(psycopg2.extensions.cursor):
    def execute(self, sql, args=None):
        logger = logging.getLogger('sql_debug')
        logger.info(self.mogrify(sql, args))

        try:
            psycopg2.extensions.cursor.execute(self, sql, args)
        except Exception as e:
            raise


conn = psycopg2.connect(host="172.17.0.3", port="2345", dbname="testDB", user="gpadmin", password="gpadmin")

cur = conn.cursor(cursor_factory=LoggingCursor)

cur.execute("select  * from user_info;")
for i in cur:
    print(i)

conn.close()