python-操作postgresql

Rainie999

　　PostgreSQL 至少有至少 3 个 Python 接口程序可
以访问 PosgreSQL: psycopg, PyPgSQL 和 PyGreSQL. 第四个, PoPy, 现在已经被废弃(2003年, 它
贡献出自己的代码, 与PygreSQL整合在一起). 这三个接口程序各有长处, 各有缺点, 根据实践结
果选择使用哪个接口是个好主意.  
 
多亏他们都支持 DB-API, 所以他们的接口基本一致, 你只需要写一个应用程序, 然后分别测
试这三个接口的性能(如果性能对你的程序很重要的化). 下面我给出这三个接口的连接代码:
psycopg
 
>>> import psycopg
>>> cxn = psycopg.connect(user='pgsql')
 
PyPgSQL
 
>>> from pyPgSQL import PgSQL
>>> cxn = PgSQL.connect(user='pgsql')
 
PyGreSQL
 
>>> import pgdb
>>> cxn = pgdb.connect(user='pgsql')
　　推荐使用http://initd.org/psycopg/
　　psycopg2 - Python-PostgreSQL Database Adapter
********************************************
　　psycopg2 is a PostgreSQL database adapter for the Python programming
language.  psycopg2 was written with the aim of being very small and fast,
and stable as a rock.
　　psycopg2 is different from the other database adapter because it was
designed for heavily multi-threaded applications that create and destroy
lots of cursors and make a conspicuous number of concurrent INSERTs or
UPDATEs. psycopg2 also provide full asycronous operations and support
for coroutine libraries.
　　1、下载，在WIN下可以直接下载它的安装包
　　2、启动pg数据库
　　3、测试代码

#!/usr/bin/env python
import psycopg2
conn= psycopg2.connect("user=adadmin dbname=admanager")
cur = conn.cursor()
cur.execute('SELECT * FROM loginuser')
rows = cur.fetchall()
for i in rows:
print i
cur.close()
conn.commit()
conn.close()

　　4、测试结果：
　　F:\pro\adreamstudio\memberman>python dbconnect.py
('admin', '******************', 1)
　　5、
　　

Psycopg Version	Python Version	PostgreSQL version built against	Release Build	Debug Build (--define PSYCOPG_DEBUG)
Current Release (2.4.2)
2.4.2 (For Python 2.4)	2.4	9.0.4	psycopg2-2.4.2.win32-py2.4-pg9.0.4-release.exe	<!-- <A href="http://www.stickpeople.com/projects/python/win-psycopg/psycopg2-2.4.2.win32-py2.4-pg9.0.4-debug.exe">psycopg2-2.4.2.win32-py2.4-pg9.0.4-debug.exe</A> -->
2.4.2 (For Python 2.5)	2.5	9.0.4	psycopg2-2.4.2.win32-py2.5-pg9.0.4-release.exe	<!-- <A href="http://www.stickpeople.com/projects/python/win-psycopg/psycopg2-2.4.2.win32-py2.5-pg9.0.4-debug.exe">psycopg2-2.4.2.win32-py2.5-pg9.0.4-debug.exe</A> -->
2.4.2 (For Python 2.6)	2.6	9.0.4	psycopg2-2.4.2.win32-py2.6-pg9.0.4-release.exe	<!-- <A href="http://www.stickpeople.com/projects/python/win-psycopg/psycopg2-2.4.2.win32-py2.6-pg9.0.4-debug.exe">psycopg2-2.4.2.win32-py2.6-pg9.0.4-debug.exe</A> -->
(For Python 2.6 amd64) (64bit Windows)	2.6	9.0.4	psycopg2-2.4.2.win-amd64-py2.6-pg9.0.4-release.exe	<!-- <A href="http://www.stickpeople.com/projects/python/win-psycopg/psycopg2-2.4.2.win-amd64-py2.6-pg9.0.4-debug.exe">psycopg2-2.4.2.win-amd64-py2.6-pg9.0.4-debug.exe</A> -->
2.4.2 (For Python 2.7)	2.7	9.0.4	psycopg2-2.4.2.win32-py2.7-pg9.0.4-release.exe	<!-- <A href="http://www.stickpeople.com/projects/python/win-psycopg/psycopg2-2.4.2.win32-py2.7-pg9.0.4-debug.exe">psycopg2-2.4.2.win32-py2.7-pg9.0.4-debug.exe</A> -->
(For Python 2.7 amd64) (64bit Windows)	2.7	9.0.4	psycopg2-2.4.2.win-amd64-py2.7-pg9.0.4-release.exe	<!-- <A href="http://www.stickpeople.com/projects/python/win-psycopg/psycopg2-2.4.2.win-amd64-py2.7-pg9.0.4-debug.exe">psycopg2-2.4.2.win-amd64-py2.7-pg9.0.4-debug.exe</A> -->
2.4.2 (For Python 3.2)	3.2	9.0.4	psycopg2-2.4.2.win32-py3.2-pg9.0.4-release.exe
(For Python 3.2 amd64) (64bit Windows)	3.2	9.0.4	psycopg2-2.4.2.win-amd64-py3.2-pg9.0.4-release.exe