sanya-dbms/processing/tools/PostgreSQL/PgExxcute.py

# -*- coding: utf-8 -*-

__author__ = 'wanger'
__date__ = '2024-08-20'
__copyright__ = '(C) 2024 by siwei'
__revision__ = '1.0'

import psycopg2

# 配置数据库连接参数并指定schema
connparams = {
    "dbname": "real3d",
    "user": "postgres",
    "password": "postgis",
    "host": "192.168.60.62",
    "port": "5432",
    "options": "-c search_path=otherSchema,base"
}
conn = psycopg2.connect(**connparams)
# 创建一个游标对象
cur = conn.cursor()