forked from python-postgres/fe
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathREADME
More file actions
48 lines (30 loc) · 1.1 KB
/
README
File metadata and controls
48 lines (30 loc) · 1.1 KB
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
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