Python直接访问Postgresql，实践通过

Python 2.7.6   Postgresql 8.4

 

安装PyGreSQL-4.1.1.win32-py2.7.exe

 

import pg

 

def yourfunction():

 

      db = pg.connect(dbname=?,host=?,user=?,port=?,passwd=?)

      res = db.query("select ****").dictresult()

      print res

      db.close

 

yourfunction()