python操作postgreSQL

1.PsyCopg的下载

　　官网下载psycopg2-2.5.1.tar.gz：http://initd.org/psycopg/

　　本文使用windows系统开发，未使用官网版本，选择psycopg2-2.4.2.win-amd64-py2.7-pg9.0.4-release.exe版，地址：http://vdisk.weibo.com/s/Cd8pPaw56Ozys

2.代码

__author__ = 'Administrator'
import  psycopg2
conn =psycopg2.connect(database="test",user="postgres",password="shanghai",host="localhost",port="5432" )
cur=conn.cursor()
cur.execute("CREATE TABLE test(id serial PRIMARY  KEY ,num INTEGER ,data VARCHAR );")
cur.execute("INSERT INTO test(num,data)  values(%s,%s)",(1,'aaa'))
cur.execute("INSERT INTO test(num,data)  values(%s,%s)",(2,'bbb'))
cur.execute("INSERT INTO test(num,data)  values(%s,%s)",(3,'ccc'))
cur.execute("select * from test;")
rows=cur.fetchall()
for i in rows:
    print(i)
conn.commit()
conn.close()