PostgreSQL driver and tools library
Version: 0.9.0py-postgresql is a set of Python library providing interfaces to various parts of PostgreSQL. Notably, it provides a pure-Python driver + C optimizations for querying a PostgreSQL database.
License: BSD License
Operating System: Linux
Sample PG-API Code:
>>> import postgresql
>>> db = postgresql.open('pq://user:password@host:port/database')
>>> db.execute("CREATE TABLE emp (emp_first_name text, emp_last_name text, emp_salary numeric)")
>>> make_emp = db.prepare("INSERT INTO emp VALUES ($1, $2, $3)")
>>> make_emp("John", "Doe", "75,322")
>>> with db.xact():
... make_emp("Jane", "Doe", "75,322")
... make_emp("Edward", "Johnson", "82,744")
There is a DB-API 2.0 module as well:
However, PG-API is recommended as it provides greater utility.
Once installed, try out the pg_python console script:
$ pg_python -h localhost -p port -U theuser -d database_name
If a successful connection is made to the remote host, it will provide a Python console with the database connection bound to the db name.