PostgreSQL Functions
PHP Manual

pg_lo_read_all

Reads an entire large object and send straight to browser

Description

int pg_lo_read_all(PgSql\Lob $lob)

pg_lo_read_all reads a large object and passes it straight through to the browser after sending all pending headers. Mainly intended for sending binary data like images or sound.

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

Note:

This function used to be called pg_loreadall.

Parameters

lob

An PgSql\Lob instance, returned by pg_lo_open.

Return Values

Number of bytes read.

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_read_all example

<?php
   header('Content-type: image/jpeg');
   $image_oid = 189762345;
   $database = pg_connect("dbname=jacarta");
   pg_query($database, "begin");
   $handle = pg_lo_open($database, $image_oid, "r");
   pg_lo_read_all($handle);
   pg_query($database, "commit");
?>

See Also

  • pg_lo_read