12345678910111213141516171819202122 |
- # -*- 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()
|