pg_lo_export

pg_lo_export

Export a large object to file

bool **pg_lo_export** PgSql\Connection $connection int $oid string $pathname

takes a large object in a

PostgreSQL database and saves its contents to a file on the local filesystem. pg_lo_export

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

Opmerking: > This function used to be called . pg_loexport

connection``oid The of the large object in the database. OID

pathnameThe full path and file name of the file in which to write the large object on the client filesystem.

return.success

Voorbeeld: example

<?php
   $database = pg_connect("dbname=jacarta");
   pg_query($database, "begin");
   $oid = pg_lo_create($database);
   $handle = pg_lo_open($database, $oid, "w");
   pg_lo_write($handle, "large object data");
   pg_lo_close($handle);
   pg_lo_export($database, $oid, '/tmp/lob.dat');
   pg_query($database, "commit");
?>

pg_lo_import