pg_lo_unlink(3) [php man page]

PG_LO_UNLINK(3) 														   PG_LO_UNLINK(3)

pg_lo_unlink - Delete a large object

SYNOPSIS

       bool pg_lo_unlink (resource  $connection, int  $oid)

DESCRIPTION

       pg_lo_unlink(3) deletes a large object with the $oid. Returns TRUE on success or FALSE on failure.

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

       Note

	       This function used to be called pg_lounlink(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.

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

EXAMPLES

       Example #1

	      pg_lo_unlink(3) example

	      <?php
		 // OID of the large object to delete
		 $doc_oid = 189762345;
		 $database = pg_connect("dbname=jacarta");
		 pg_query($database, "begin");
		 pg_lo_unlink($database, $doc_oid);
		 pg_query($database, "commit");
	      ?>

SEE ALSO

       pg_lo_create(3), pg_lo_import(3).

PHP Documentation Group 													   PG_LO_UNLINK(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)