File: README

package info (click to toggle)
py-postgresql 1.0.2-1
  • links: PTS, VCS
  • area: main
  • in suites: wheezy
  • size: 3,176 kB
  • sloc: python: 18,255; ansic: 2,038; sql: 255; makefile: 28; sh: 5
file content (57 lines) | stat: -rw-r--r-- 1,449 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
49
50
51
52
53
54
55
56
57
About py-postgresql
===================

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.

The goal of this project is to provide substantial convenience to Python
developers working with PostgreSQL.


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 is recommended as it provides more utility for the user::

	>>> 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: `postgresql.driver.dbapi20`.


Further Information
-------------------

The documentation package, `postgresql.documentation.index`, contains more
detailed information on the modules herein, and HTML versions of the
documentation can be found at:

	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