FileBuzz: Software Download
Find shareware, freeware downloads from thousands of software titles

Program Name: pg/python

License Type: Freeware

Date Released: May 26, 2013

pg/python v1.0 Instant Download

pg/python Desciption:


pg/python is an open source project working toward the improvement of Python interfaces to PostgreSQL.Quick start:Fetch and Install pg_probosciseasy_install pg_proboscisConnect to a database with the frontendimport as pqCon = 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, pronargsint2, prorettype oid, proargtypes oidvector, proargnames _text, prosrc text,probin bytea, proacl _aclitem,)print repr(x["proname"])'byteain'::nameprint repr(x[0])'byteain'::namefor y in x: print repr(y)'byteain'::name'11'::oid'1'::int4'12'::oidFalseFalseTrueFalse'i'::char'1'::int2'17'::oid'2275'::oidvectorNone'byteain'::text'-'::bytea'{=X/pgsql}'::_aclitemprint x["proacl"][0]=X/pgsqlPlease be sure to see the documentation for more details.

License: Freeware | Price: $0.00 | Size: 32 KB | Downloads (130)

Platform: Linux

Related Software
New Reviews
New Downloads Top Downloads Top Search

New Downloads

Network Shares Recycle Bin
VLC Player MSI Installer
DiskGenius Standard
PuTTy MSI Installer
WinCln .NET
WinExt Batch Operator
BurnAware Free
ChequePulse Cheque Printing Software
HttpMaster Express
HttpMaster Professional
Aiseesoft Mac Cleaner
PDF Shaper Professional
IDpack Business
IGES Viewer alias ABViewer
JoyoPlayer for Windows
Mirekusoft Install Monitor
Smart Defrag
APKF Product Key Finder

Top Downloads

Opera Mini
Turbo C++
Abyss Web Server X1
TaskMerlin Project Management Software
Macrorit Disk Partition Expert Server Edition
Foxit Advanced PDF Editor
Kids Online Browser
Rapid PHP Editor
Cleanup and Update Tool for Cisco CUCM
Open-School Community Edition
Count Code
simplitec simplisafe
Multi-Process Killer Portable
SCEA Part 2 & 3 Exam EPractize Labs Enterprise
Silva 2.1a2
Agama Web Menus
aXmag Free
Flash Player Pro
Red Call Recorder
Syston Data Recovery Free
Photo! 3D Album
Photo! Editor
Sondle Virtual Desktop Assist

Top Search

Python Simple Smtp Server
Convert Raster To Vector Python
Python Data Logging
Python Gauge
Python Simple Chat Program
Perl Python Compare
Python Iis Log File
Python Ftp Sample Multiple Files
Python Password Keeper
Python Tetris Source
Python Workflow Builder
How To Make A Python Vpn
Python Capture Network Traffic
Convert Xml Xls To Csv Python
Python Extension Spss
Python Report Framework
Python Grab Image From Web Camera
File Transfer Python
Python Directory Comparison Script
Cisco Python Script
Useful Python Scripts For Windows
Python Transfer Speed
Python Wireless Communications
Pg And Pb Loader
Create Database Diagram Pg Designer