-
Notifications
You must be signed in to change notification settings - Fork 35
py-postgresql: Query a PostgreSQL database with Python 3 using the PQv3 protocol.
License
python-postgres/fe
Folders and files
| Name | Name | Last commit message | Last commit date | |
|---|---|---|---|---|
Repository files navigation
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.
Installation
------------
Installation *should* be as simple as::
$ python3 ./setup.py install
More information about installation is available via::
python -m postgresql.documentation.admin
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
About
py-postgresql: Query a PostgreSQL database with Python 3 using the PQv3 protocol.
Topics
Resources
License
Stars
Watchers
Forks
Packages 0
No packages published