Python PostgreSQL operations

2005-2-23
This post is really a long time apart from the previous one, and it continues to work harder!

Today, let's try Python's database operation capabilities: Using python to connect to PostgreSQL (my favorite ).

First install PostgreSQL, http://www.postgresql.org
Then I checked it on the PostgreSQL website, and there was a python Connection Program pygresql.

It is divided into two modules: the old PG and the new pgdb.
PG documentation: http://www.pgsqldb.org/pgsqldoc-7.2c/pygresql.html
Pgdb documentation: http://www.python.org/peps/pep-0249.html

Today, let's try pg. The code is really simple:

Import PG DB = pg. Connect (dbname = 'yanxu ', host = 'localhost', user = 'qingfeng', passwd = '000000 ') For OBJ in db. Query ("select * From Table1". dictresult (): Print OBJ ['user _ name'] DB. Close ()