python-base--/tmp/green_plum.py

import pandas as pd
import psycopg2


def queryGP(sql):
    # 连接到一个给定的数据库
    conn = psycopg2.connect(dbname="cdpqa", user="cdpqa", password="Cdpqa@123456", port="5432",
                            host="eip-greenplum-2.qa.mlamp.cn", client_encoding="UTF-8")
    df = pd.read_sql(sql, con=conn)
    # 关闭数据库连接
    conn.close()
    return df


df = queryGP("select * from pg_tables")
print(df)