PgExxcute.py 485 B

123456789101112131415161718192021
  1. # -*- coding: utf-8 -*-
  2. __author__ = 'wanger'
  3. __date__ = '2024-08-20'
  4. __copyright__ = '(C) 2024 by siwei'
  5. __revision__ = '1.0'
  6. import psycopg2
  7. # 配置数据库连接参数并指定schema
  8. connparams = {
  9. "dbname": "real3d",
  10. "user": "postgres",
  11. "password": "postgis",
  12. "host": "192.168.60.62",
  13. "port": "5432",
  14. "options": "-c search_path=otherSchema,base"
  15. }
  16. conn = psycopg2.connect(**connparams)
  17. # 创建一个游标对象
  18. cur = conn.cursor()