About Site Map Submit Contact Us Log in | Create an account
Create an account Log In
Average Rating
User Rating:
Visitors Rating:
My rating:

Write review
See full specifications

linux default iconpg/python Publisher's description

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

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()

# 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"])
print repr(x[0])

for y in x: print repr(y)


print x["proacl"][0]

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.

System Requirements:

No special requirements.
Program Release Status:
Program Install Support: Install and Uninstall

pg/python Tags:

Click on a tag to find related softwares

Most Popular

linux default icon A2Billing 1.6.0
A2Billing is a billing system interactive with Asterisk to give any Telecom company traditional offering VOIP... Read more
linux default icon FrontAccounting 2.3.10
FrontAccounting is free and released under the GNU General Public License.
linux default icon PgAdmin III for Linux 1.14.1
pgAdmin is the most popular and feature rich Open Source administration and development platform for... Read more
linux default icon RazorSQL for Linux 5.6.3
RazorSQL is an SQL query tool, database browser, SQL editor,....
linux default icon Salat Book 1.00
Salat / Namaz prayer database and tracking application