Be careful: pg_lo_export() create empty file without "begin"/"end".
See docs: "...it is necessary to enclose it within a transaction block..."
(PHP 4 >= 4.2.0, PHP 5)
pg_lo_read — Read a large object
pg_lo_read() 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.
Забележка: This function used to be called pg_loread().
PostgreSQL large object (LOB) resource, returned by pg_lo_open().
An optional maximum number of bytes to return. Defaults to 8192.
A string containing len bytes from the large object, or FALSE on error.
Example #1 pg_lo_read() example
$doc_oid = 189762345;
$database = pg_connect("dbname=jacarta");
$handle = pg_lo_open($database, $doc_oid, "r");
$data = pg_lo_read($handle, 50000);
- pg_lo_read_all() - Reads an entire large object and send straight to browser