Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

pg_lo_create(3) [php man page]

PG_LO_CREATE(3) 														   PG_LO_CREATE(3)

pg_lo_create - Create a large object

SYNOPSIS
int pg_lo_create ([resource $connection], [mixed $object_id]) DESCRIPTION
int pg_lo_create (mixed $object_id) pg_lo_create(3) creates a large object and returns the $OID of the large object. PostgreSQL access modes INV_READ, INV_WRITE, and INV_AR- CHIVE are not supported, the object is created always with both read and write access. INV_ARCHIVE has been removed from PostgreSQL itself (version 6.3 and above). To use the large object interface, it is necessary to enclose it within a transaction block. Instead of using the large object interface (which has no access controls and is cumbersome to use), try PostgreSQL's $bytea column type and pg_escape_bytea(3). Note This function used to be called pg_locreate(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 $object_id - If an $object_id is given the function will try to create a large object with this id, else a free object id is assigned by the server. The parameter was added in PHP 5.3 and relies on functionality that first appeared in PostgreSQL 8.1. RETURN VALUES
A large object $OID or FALSE on error. CHANGELOG
+--------+-------------------------------------+ |Version | | | | | | | Description | | | | +--------+-------------------------------------+ | 5.3.0 | | | | | | | The optional $object_id was added. | | | | +--------+-------------------------------------+ EXAMPLES
Example #1 pg_lo_create(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"); ?> PHP Documentation Group PG_LO_CREATE(3)

Check Out this Related Man Page

PG_LO_SEEK(3)															     PG_LO_SEEK(3)

pg_lo_seek - Seeks position within a large object

SYNOPSIS
bool pg_lo_seek (resource $large_object, int $offset, [int $whence = PGSQL_SEEK_CUR]) DESCRIPTION
pg_lo_seek(3) seeks a position within a large object resource. To use the large object interface, it is necessary to enclose it within a transaction block. PARAMETERS
o $large_object - PostgreSQL large object (LOB) resource, returned by pg_lo_open(3). o $offset - The number of bytes to seek. o $whence - One of the constants PGSQL_SEEK_SET (seek from object start), PGSQL_SEEK_CUR (seek from current position) or PGSQL_SEEK_END (seek from object end) . RETURN VALUES
Returns TRUE on success or FALSE on failure. EXAMPLES
Example #1 pg_lo_seek(3) example <?php $doc_oid = 189762345; $database = pg_connect("dbname=jacarta"); pg_query($database, "begin"); $handle = pg_lo_open($database, $doc_oid, "r"); // Skip first 50000 bytes pg_lo_seek($handle, 50000, PGSQL_SEEK_SET); // Read the next 10000 bytes $data = pg_lo_read($handle, 10000); pg_query($database, "commit"); echo $data; ?> CHANGELOG
+--------+---------------------------------------------------+ |Version | | | | | | | Description | | | | +--------+---------------------------------------------------+ | 5.6.0 | | | | | | | Added PostgreSQL 9.3's 64bit large object sup- | | | port. Both client and server must support Post- | | | greSQL 9.3 and PHP must be 64bit build to use | | | 64bit large object. | | | | +--------+---------------------------------------------------+ SEE ALSO
pg_lo_tell(3). PHP Documentation Group PG_LO_SEEK(3)
Man Page