Python Operations PostgreSQL

2005-2-23
This post is really a long time apart than the last one, continue to Dmitri Trenin!

Let's try Python's database operations today: Connect PostgreSQL with Python (personal favorites).

First install postgresql,http://www.postgresql.org
Then went to PostgreSQL's website to check it out, and sure enough there was a Python connection program Pygresql

He was divided into two modules, the old PG, and the new pgdb
PG Documentation: Http://www.pgsqldb.org/pgsqldoc-7.2c/pygresql.html
PGDB's Documentation: http://www.python.org/peps/pep-0249.html

Let's try PG today, and the code is simple enough:


Import PG

db = Pg.connect (dbname= ' Yanxu ', host= ' localhost ', user= ' Qingfeng ', passwd= ' 123 ')
For obj in Db.query ("SELECT * FROM table1". Dictresult ():
Print obj[' user_name ']

Db.close ()