Re: How to get the size of a large object?

This really doesn't answer your question. But maybe it will achieve the
same result.

PHP has a function called pg_loreadall. This function reads a large
object and passes it straight through to the browser.

Here is an example
<?
$db = pg_connect("your connect string");
pg_exec($db, "begin");
$result = pg_exec($db, "select image_oid,
image_header
from image_mstr
where image_id = 1");
$row = pg_fetch_row($result, 0);
pg_exec($db, "end");
$image_oid = $row[0];
$header = $row[1];
pg_exec($db, "begin");
$fh = pg_loopen($db, $image_oid, "r");
Header($header);
pg_loreadall($fh);
pg_loclose($fh);
pg_exec($db, "end");
pg_close($db);
?>

On Fri, 21 Apr 2000, Robert B. Easter wrote:

> I use php4 and I'm wondering if there is a way to find out the size of a large
> object so that when I call pg_loread($fd, $len), I can set $len to the correct
> number of bytes to read in. Does the database maintain this information
> anywhere accessible by a query? I could store the sizes in a table along with
> the oids but would rather not if I don't need to.
>