pg_lo_open

Open a large object (PHP 4 >= 4.2.0, PHP 5)
resource pg_lo_open ( resource connection, int oid, string mode )

pg_lo_open() opens a large object in the database and returns large object resource so that it can be manipulated.

Warning:

Do not close the database connection before closing the large object resource.

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

Note:

This function used to be called pg_loopen().

Parameters

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() or pg_pconnect().
oid: The OID of the large object in the database.
mode: Can be either "r" for read-only, "w" for write only or "rw" for read and write.

Return Values

A large object resource or FALSE on error.

Examples

Example 1947. pg_lo_open() example

copy to clipboard

<?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_close()

pg_lo_create()

Code Examples / Notes » pg_lo_open

metator

Just for the record, a user must be a superuser (database owner) in order to invoke pg_lo_open() (though pg_lo_create() may be invoked...). This opens a gigantic security hole in the db. If a user is not a superuser, db will raise an error with message "Can't create Large Object.". Thus, imho, one should use pg_escape_bytea() instead.

riccardo_ridenti

//INSERT FILE INTO DB $fp = fopen($filename,"r"); $buffer = fread($fp,filesize($filename)); fclose($fp); pg_query ($conn, "begin"); $oid = pg_lo_create ($conn); //echo "$oid\n"; $rs = pg_exec($conn,"insert into table(object) values($oid);");//object field type must be "oid" $handle = pg_lo_open ($conn, $oid, "w"); //echo "$handle\n"; pg_lo_write ($handle, $buffer); pg_lo_close ($handle); pg_query ($conn, "commit"); //OR END pg_close(); //GET BUFFER(file) FROM DB $rs = pg_exec($conn,"select object from objects where id = xxxxxx;"); $row = pg_fetch_row($rs,0); pg_query ($conn, "begin"); $loid = pg_lo_open($conn,$row[0], "r"); pg_lo_read_all ($loid); pg_lo_close ($loid); pg_query ($conn, "commit"); //OR END pg_close();

pg_lo_open

Open a large object (PHP 4 >= 4.2.0, PHP 5) resource pg_lo_open ( resource connection, int oid, string mode )

Parameters

Return Values

Examples

Example 1947. pg_lo_open() example

Code Examples / Notes » pg_lo_open

Change Language

Open a large object (PHP 4 >= 4.2.0, PHP 5)
resource pg_lo_open ( resource connection, int oid, string mode )