python-操作postgresql

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