# -*- coding: utf-8 -*- __author__ = 'wanger' __date__ = '2024-08-20' __copyright__ = '(C) 2024 by siwei' __revision__ = '1.0' import psycopg2 import siwei_config # 配置数据库连接参数并指定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()