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

Syntax:

connect([dbname], [host], [port], [opt], [tty], [user], [passwd])

>>> db = _pg.connect('dellstore2','localhost')
or 
db = _pg.connect('dellstore2','localhost', 5432, None, None, 'postgres', 'postgres')
or
db = _pg.connect(dbname='dellstore2', host='localhost', user='postgres', passwd='postgres')

>>> 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)