pg_lo_read(3) [php man page]

PG_LO_READ(3)															     PG_LO_READ(3)

pg_lo_read - Read a large object

SYNOPSIS

       string pg_lo_read (resource  $large_object, [int  $len = 8192])

DESCRIPTION

       pg_lo_read(3) reads at most $len bytes from a large object and returns it as a string.

	To use the large object interface, it is necessary to enclose it within a transaction block.

       Note

	       This function used to be called pg_loread(3).

PARAMETERS

	      o $large_object
		- PostgreSQL large object (LOB) resource, returned by pg_lo_open(3).

	      o $len
		- An optional maximum number of bytes to return.

RETURN VALUES

	A string containing $len bytes from the large object, or FALSE on error.

EXAMPLES

       Example #1

	      pg_lo_read(3) example

	      <?php
		 $doc_oid = 189762345;
		 $database = pg_connect("dbname=jacarta");
		 pg_query($database, "begin");
		 $handle = pg_lo_open($database, $doc_oid, "r");
		 $data = pg_lo_read($handle, 50000);
		 pg_query($database, "commit");
		 echo $data;
	      ?>

SEE ALSO

       pg_lo_read_all(3).

PHP Documentation Group 													     PG_LO_READ(3)

PG_LO_TRUNCATE(3)														 PG_LO_TRUNCATE(3)

pg_lo_truncate - Truncates a large object

SYNOPSIS

       bool pg_lo_truncate (resource  $large_object, int  $size)

DESCRIPTION

       pg_lo_truncate(3) truncates 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 $size
		- The number of bytes to truncate.

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

EXAMPLES

       Example #1

	      pg_lo_truncate(3) example

	      <?php
		 $doc_oid = 189762345;
		 $database = pg_connect("dbname=jacarta");
		 pg_query($database, "begin");
		 $handle = pg_lo_open($database, $doc_oid, "r");
		 // Truncate to 0
		 pg_lo_truncate($handle, 0);
		 pg_query($database, "commit");
		 echo $data;
	      ?>

CHANGELOG

       +--------+---------------------------------------------------+
       |Version |						    |
       |	|						    |
       |	|		     Description		    |
       |	|						    |
       +--------+---------------------------------------------------+
       | 5.6.0	|						    |
       |	|						    |
       |	|  Added  truncate function. It supports PostgreSQL |
       |	| 9.3's 64bit large object. Both client and  server |
       |	| must support PostgreSQL 9.3 and PHP must be 64bit |
       |	| build to use 64bit large object.		    |
       |	|						    |
       +--------+---------------------------------------------------+
SEE ALSO

       pg_lo_tell(3).

PHP Documentation Group 													 PG_LO_TRUNCATE(3)