File: README

package info (click to toggle)
py-postgresql 1.1.0-2
  • links: PTS, VCS
  • area: main
  • in suites: jessie, jessie-kfreebsd, sid, stretch
  • size: 1,364 kB
  • ctags: 3,170
  • sloc: python: 18,318; ansic: 2,024; sql: 282; makefile: 29; sh: 26
file content (48 lines) | stat: -rw-r--r-- 1,128 bytes parent folder | download
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