PyGreSQL

PyGreSQL – PostgreSQL module for Python

It embeds the PostgreSQL query library to allow easy use of the powerful PostgreSQL features from a Python script.

http://www.pygresql.org/

Install

#apt-get install python2.3-pygresql

#su postgresql
postgres$ python 
>>> import _pg
>>> db = _pg.connect('dellstore2','localhost')
>>> db.query("select * from categories")
category|categoryname
--------+------------
       1|Action
       2|Animation
       3|Children
       4|Classics
       5|Comedy
       6|Documentary
       7|Drama
       8|Family
       9|Foreign
      10|Games
      11|Horror
      12|Music
      13|New
      14|Sci-Fi
      15|Sports
      16|Travel
(16 rows)

(1 row)