python通过PyGreSQL连接greenplum/postgresql

安装

python 2.7

安装前依赖：

apt-get install python-dev 
apt-get install postgresql
apt-get install postgresql-server-dev-all

安装PyGreSQL：

pip install PyGreSQL

测试

通过如下脚本，可以验证pygresql是否安装成功：

#!/usr/bin/env python

import pg


def operate_postgre_tbl_product():
    try:
        #pgdb_conn = pg.connect(dbname = 'tpc', host = '192.168.103.31', user = 'gpadmin', passwd = '')
        pgdb_conn = pg.connect("host=192.168.103.31 port=5432 dbname=tpc user=gpadmin")

    except Exception, e:
         print e.args[0]
         return


    sql_desc = "select * from call_center limit 5;"
    for row in pgdb_conn.query(sql_desc).dictresult():
        print row


    pgdb_conn.close()


if __name__ == '__main__':
    operate_postgre_tbl_product()

上面代码是连接了一个数据库，然后尝试获取几行数据。这是个greenplum数据库，没有设置密码