pg_lo_truncate(3) [php man page]

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)

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)