python连接postgis_python连接postgres方法

Python使用PyGreSQL操作PostgreSQL：

import pgdef operate_postgre_tbl_product(): try:

#db

= pg.connect(dbname = "postgres", host = "192.168.1.200", user = "postgres", passwd = "postgres"

) 方法一

db

= pg.connect("host=192.168.1.200 port=5432 dbname=postgres user=postgres"

) 方法二 except Exception as e: print (e.args[

0

]) return sql_desc=

"

select * from zhang;

"

for row

in

db.query(sql_desc).dictresult(): print (row) db.close()

if __name__ ==

"

__main__

"

: operate_postgre_tbl_product()

PostgreSQL可以使用psycopg2模块与Python集成。sycopg2是用于Python编程语言的PostgreSQL数据库适配器。 psycopg2是非常小，快速，稳定的。## 导入psycopg2包import psycopg2## 连接到一个给定的数据库

conn

=