PgExxcute.py 506 B

12345678910111213141516171819202122
  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. import siwei_config
  8. # 配置数据库连接参数并指定schema
  9. connparams = {
  10. "dbname": "real3d",
  11. "user": "postgres",
  12. "password": "postgis",
  13. "host": "192.168.60.62",
  14. "port": "5432",
  15. "options": "-c search_path=otherSchema,base"
  16. }
  17. conn = psycopg2.connect(**connparams)
  18. # 创建一个游标对象
  19. cur = conn.cursor()