如何通过python获得对heroku-postgresql数据库的完全访问权限

import psycopg2

# 数据库连接信息
host = "your_host"
port = "your_port"
database = "your_database"
user = "your_username"
password = "your_password"

# 建立数据库连接
conn = psycopg2.connect(
    host=host,
    port=port,
    database=database,
    user=user,
    password=password
)

# 创建游标对象
cur = conn.cursor()

# 执行SQL查询
cur.execute("SELECT * FROM your_table")

# 获取查询结果
result = cur.fetchall()

# 执行SQL操作
cur.execute("INSERT INTO your_table (column1, column2) VALUES (%s, %s)", (value1, value2))

# 提交事务
conn.commit()

# 关闭游标和数据库连接
cur.close()
conn.close()