PostgreSQL是一款功能強大的開源關(guān)系型數(shù)據(jù)庫，本文使用python實現(xiàn)了對開源數(shù)據(jù)庫PostgreSQL的常用操作，其開發(fā)過程簡介如下：

一、環(huán)境信息：

   1、操作系統(tǒng)：

        RedHat Enterprise Linux 4
        Windows XP SP2

  2、數(shù)據(jù)庫：

        PostgreSQL8.3

  3、 開發(fā)工具:

        Eclipse+Pydev+python2.6+PyGreSQL(提供pg模塊)

  4、說明：

        a、PostgreSQL數(shù)據(jù)庫運行于RedHat Linux上，Windows下也要安裝pgAdmin（訪問PostgreSQL服務(wù)器的客戶端）。
        b、PyGreSQL(即pg)模塊下載路徑及API手冊：http://www.pygresql.org/
 PyGreSQL模塊點此本站下載

二、配置：

       1、將pgAdmin安裝路徑下以下子目錄添加到系統(tǒng)環(huán)境變量中:

             E:/Program Files/PostgreSQL/8.3/lib

             E:/Program Files/PostgreSQL/8.3/bin

       2、將python安裝目錄C:/Python26/Lib/site-packages/pywin32_system32下的dll文件拷貝到C:/WINDOWS/system32

       3、說明：如果跳過以上兩步，在import pg時將會報錯，并且會浪費較長時間才能搞定。

三、程序?qū)崿F(xiàn)：

#!/usr/bin/env python# -*- coding: utf-8 -*-#導(dǎo)入日志及pg模塊import loggingimport logging.configimport pg#日志配置文件名LOG_FILENAME = 'logging.conf'#日志語句提示信息LOG_CONTENT_NAME = 'pg_log'def log_init(log_config_filename, logname):  '''  Function:日志模塊初始化函數(shù)  Input：log_config_filename:日志配置文件名      lognmae:每條日志前的提示語句  Output: logger  author: socrates  date:2012-02-12  '''  logging.config.fileConfig(log_config_filename)  logger = logging.getLogger(logname)  return loggerdef operate_postgre_tbl_product():  '''  Function:操作pg數(shù)據(jù)庫函數(shù)  Input：NONE  Output: NONE  author: socrates  date:2012-02-12  '''   pgdb_logger.debug("operate_postgre_tbl_product enter...")     #連接數(shù)據(jù)庫   try:    pgdb_conn = pg.connect(dbname = 'kevin_test', host = '192.168.230.128', user = 'dyx1024', passwd = '888888')  except Exception, e:     print e.args[0]     pgdb_logger.error("conntect postgre database failed, ret = %s" % e.args[0])       return       pgdb_logger.info("conntect postgre database(kevin_test) succ.")       #刪除表  sql_desc = "DROP TABLE IF EXISTS tbl_product3;"  try:    pgdb_conn.query(sql_desc)  except Exception, e:    print 'drop table failed'    pgdb_logger.error("drop table failed, ret = %s" % e.args[0])    pgdb_conn.close()     return    pgdb_logger.info("drop table(tbl_product3) succ.")    #創(chuàng)建表  sql_desc = '''CREATE TABLE tbl_product3(    i_index INTEGER,    sv_productname VARCHAR(32)    );'''  try:      pgdb_conn.query(sql_desc)  except Exception, e:    print 'create table failed'    pgdb_logger.error("create table failed, ret = %s" % e.args[0])    pgdb_conn.close()     return        pgdb_logger.info("create table(tbl_product3) succ.")      #插入記錄    sql_desc = "INSERT INTO tbl_product3(sv_productname) values('apple')"  try:    pgdb_conn.query(sql_desc)  except Exception, e:    print 'insert record into table failed'    pgdb_logger.error("insert record into table failed, ret = %s" % e.args[0])    pgdb_conn.close()     return       pgdb_logger.info("insert record into table(tbl_product3) succ.")        #查詢表 1      sql_desc = "select * from tbl_product3"  for row in pgdb_conn.query(sql_desc).dictresult():    print row    pgdb_logger.info("%s", row)    #查詢表2      sql_desc = "select * from tbl_test_port"  for row in pgdb_conn.query(sql_desc).dictresult():    print row     pgdb_logger.info("%s", row)         #關(guān)閉數(shù)據(jù)庫連接     pgdb_conn.close()      pgdb_logger.debug("operate_sqlite3_tbl_product leaving...") if __name__ == '__main__':     #初始化日志系統(tǒng)  pgdb_logger = log_init(LOG_FILENAME, LOG_CONTENT_NAME)      #操作數(shù)據(jù)庫  operate_postgre_tbl_product()