About

py-postgresql is a Python 3 package providing modules to work with PostgreSQL. This includes a high-level driver, and many other tools that support a developer working with PostgreSQL databases.

This fork vs original

Forked from python-postgres/fe to better support Postgres stored procedures, because the original isn't adequately maintained.

Installation

Installation should be as simple as::

$ python3 ./setup.py install

More information about installation is available via::

python -m postgresql.documentation.admin

Using pip

$ pip3 install git+https://github.com/Mayzie/fe.git

Basic Driver Usage

Using PG-API::

>>> import postgresql
>>> db = postgresql.open('pq://user:password@host:port/database')
>>> get_table = db.prepare("select * from information_schema.tables where table_name = $1")
>>> for x in get_table("tables"):
>>>  print(x)
>>> print(get_table.first("tables"))

However, a DB-API 2.0 driver is provided as well: postgresql.driver.dbapi20.

Further Information

Online documentation can be retrieved from:

http://python.projects.postgresql.org

Or, you can read them in your pager: python -m postgresql.documentation.index

For information about PostgreSQL:

http://postgresql.org

For information about Python:

http://python.org