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_TELL(3)															     PG_LO_TELL(3)

pg_lo_tell - Returns current seek position a of large object

SYNOPSIS

       int pg_lo_tell (resource  $large_object)

DESCRIPTION

       pg_lo_tell(3) returns the current position (offset from the beginning) of a large object.

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

RETURN VALUES

	The current seek offset (in number of bytes) from the beginning of the large object. If there is an error, the return value is negative.

EXAMPLES

       Example #1

	      pg_lo_tell(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);
		 // See how far we've skipped
		 $offset = pg_lo_tell($handle);
		 echo "Seek position is: $offset";
		 pg_query($database, "commit");
	      ?>

	      The above example will output:

	      Seek position is: 50000

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_seek(3).

PHP Documentation Group 													     PG_LO_TELL(3)