Explore your database with Talend Open Profiler


 
Thread Tools Search this Thread
Special Forums News, Links, Events and Announcements UNIX and Linux RSS News Explore your database with Talend Open Profiler
# 1  
Old 07-18-2008
Explore your database with Talend Open Profiler

07-18-2008 11:00 AM
Over time, organizations replicate, migrate, or add complexity within database systems, often times losing control of the quality of their data. When applications begin to fail because of invalid, corrupted, or out-of-date data, the free, GPL-licensed Talend Open Profiler can give data analysts, database administrators (DBA), and business users the ability to research data structures and improve data quality. Through the use of Open Profiler, users can be alerted to hidden inconsistencies and incompatibilities between data sources and target applications. Through data analysis, business users and technical analysts can communicate both data structure and content needs.



Source...
Login or Register to Ask a Question

Previous Thread | Next Thread
Login or Register to Ask a Question
PG_LO_OPEN(3)															     PG_LO_OPEN(3)

pg_lo_open - Open a large object

SYNOPSIS
resource pg_lo_open (resource $connection, int $oid, string $mode) DESCRIPTION
pg_lo_open(3) opens a large object in the database and returns large object resource so that it can be manipulated. Warning Do not close the database connection before closing the large object resource. To use the large object interface, it is necessary to enclose it within a transaction block. Note This function used to be called pg_loopen(3). PARAMETERS
o $connection - PostgreSQL database connection resource. When $connection is not present, the default connection is used. The default connection is the last connection made by pg_connect(3) or pg_pconnect(3). o $oid - The $OID of the large object in the database. o $mode - Can be either "r" for read-only, "w" for write only or "rw" for read and write. RETURN VALUES
A large object resource or FALSE on error. EXAMPLES
Example #1 pg_lo_open(3) example <?php $database = pg_connect("dbname=jacarta"); pg_query($database, "begin"); $oid = pg_lo_create($database); echo "$oid "; $handle = pg_lo_open($database, $oid, "w"); echo "$handle "; pg_lo_write($handle, "large object data"); pg_lo_close($handle); pg_query($database, "commit"); ?> SEE ALSO
pg_lo_close(3), pg_lo_create(3). PHP Documentation Group PG_LO_OPEN(3)