pg/python 1.0

pg/python is an open source project working toward the improvement of Python interfaces to PostgreSQL.

  Add it to your Download Basket!

 Add it to your Watch List!

0/5

Rate it!
send us
an update
LICENSE TYPE:
BSD License 
USER RATING:
2.6/5 18
DEVELOPED BY:
pg/python project
HOMEPAGE:
python.projects.postgresql.org
CATEGORY:
ROOT \ Database \ Administrative frontents
1 pg/python Screenshot:
pg/python
pg/python is an open source project working toward the improvement of Python interfaces to PostgreSQL.

Quick start:

Fetch and Install pg_proboscis

easy_install pg_proboscis

Connect to a database with the frontend

import postgresql.interface.proboscis.prime as pq
Con = pq.Connector(
user = 'root',
host = 'localhost',
port = 5432,
ssl = True, # Optional. Only set it to True if you want it.
database = 'pgsql',
)
# This creates a Connection *class*, it still needs to be instantiated.
C = Con()
C


# Let's query the database; your results may vary.
Q = C.Query("SELECT * FROM pg_proc WHERE proname = $1")
P = Q('byteain')
for x in P: print x
('byteain'::name, '11'::oid, '1'::int4, '12'::oid, False, False, True, False,
'i'::char, '1'::int2, '17'::oid, '2275'::oidvector, None, 'byteain'::text,
'-'::bytea, '{=X/pgsql}'::_aclitem)
print type(x)
(proname name, pronamespace oid, proowner int4, prolang oid, proisagg bool,
prosecdef bool, proisstrict bool, proretset bool, provolatile char, pronargs
int2, prorettype oid, proargtypes oidvector, proargnames _text, prosrc text,
probin bytea, proacl _aclitem,)

print repr(x["proname"])
'byteain'::name
print repr(x[0])
'byteain'::name

for y in x: print repr(y)

'byteain'::name
'11'::oid
'1'::int4
'12'::oid
False
False
True
False
'i'::char
'1'::int2
'17'::oid
'2275'::oidvector
None
'byteain'::text
'-'::bytea
'{=X/pgsql}'::_aclitem

print x["proacl"][0]
=X/pgsql

Please be sure to see the documentation for more details.

What's New in This Release:

The API was stabilized.
Many bugs were fixed and many features were completed.

Last updated on June 1st, 2008

#PostgreSQL interface #database frontend #Python interface #PostgreSQL #database #Python #interface

Add your review!

SUBMIT