PostgreSQL Functions
PHP Manual

pg_lo_close

Close a large object

Description

bool pg_lo_close(PgSql\Lob $lob)

pg_lo_close closes a large object.

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

Note:

This function used to be called pg_loclose.

Parameters

lob

An PgSql\Lob instance, returned by pg_lo_open.

Return Values

Returns true on success or false on failure.

Changelog

Version Description
8.1.0 The lob parameter expects an PgSql\Lob instance now; previously, a resource was expected.

Examples

Example #1 pg_lo_close example

<?php
   $database = pg_connect("dbname=jacarta");
   pg_query($database, "begin");
   $oid = pg_lo_create($database);
   echo "$oid\n";
   $handle = pg_lo_open($database, $oid, "w");
   echo "$handle\n";
   pg_lo_write($handle, "large object data");
   pg_lo_close($handle);
   pg_query($database, "commit");
?>

See Also

  • pg_lo_open
  • pg_lo_create
  • pg_lo_import