1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
|
About
=====
py-postgresql is a Python 3 package providing modules for working with PostgreSQL.
This includes a high-level driver, and many other tools that support a developer
working with PostgreSQL databases.
For a high performance async interface, MagicStack's asyncpg
http://github.com/MagicStack/asyncpg should be considered.
py-postgresql, currently, does not have direct support for high-level async
interfaces provided by recent versions of Python. Future versions may change this.
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://py-postgresql.readthedocs.io
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
|
