[Python] PostgreSQL 사용하기

PyGreSQL 
http://www.pygresql.org


Python Database API Specification v2.0
http://www.python.org/dev/peps/pep-0249/

ex) SELECT

#!/usr/bin/python
# -*- coding: cp949 -*-

import pgdb

try:
    # DB 연결
    db = pgdb.connect(dsn = 'localhost:DB이름:UserID:Password')
    # cursor 객체생성
    cursor = db.cursor()
    query_string = 'SELECT * FROM 테이블이름'
    # query 실행
    cursor.execute(query_string)
    # query 실행 결과를 하나씩 빼먹는 과정
    row = cursor.fetchone()
    if row == None:
        print 'Empty result set from query => ', query_string
    else:
        while row != None:
            print '================='
            for i in range(len(row)):
                print '%s\t%s' % (i, row[i])
            row = cursor.fetchone()
        cursor.close()
except Exception, e:
    print str(e)

db.close()