Python driver for postgresql

I would recommend sqlalchemy - it offers more flexibility and has a complicated intuition.

Moreover, it is not associated only with postgresql.

Shameless c & p from tutorial :

from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker

# an Engine, which the Session will use for connection
# resources
some_engine = create_engine('postgresql://scott:tiger@localhost/')

# create a configured "Session" class
Session = sessionmaker(bind=some_engine)

# create a Session
session = Session()

# work with sess
myobject = MyObject('foo', 'bar')
session.add(myobject)
session.commit()

Clarifications due to comments (update):

sqlalchemy , - . , postgresql- libpq, psycopg2.

OP , , " " " postgresql", sqlalchemy, , , .

" " , , - , .

, .