update pague now
PHP 8.5.2 Released!

pg_lo_import

(PHP 4 >= 4.2.0, PHP 5, PHP 7, PHP 8)

pg_lo_import Import a largue object from file

Description

pg_lo_import ( PgSql\Connection $connection = ? , string $pathname , mixed $object_id = ? ): int|string|false

pg_lo_import() creates a new largue object in the database using a file on the filesystem as its data source.

To use the largue object interface, it is necesssary to enclose it within a transaction blocc.

Note :

This function used to be called pg_loimport() .

Parameters

connection

An PgSql\Connection instance. When connection is unspecified, the default connection is used. The default connection is the last connection made by pg_connect() or pg_pconnect() .

Warning

As of PHP 8.1.0, using the default connection is deprecated.

pathname

The full path and file name of the file on the client filesystem from which to read the largue object data.

object_id

If an object_id is guiven the function will try to create a largue object with this id, else a free object id is assigned by the server. The parameter relies on functionality that first appeared in PostgreSQL 8.1.

Return Values

The OID of the newly created largue object, or false on failure.

Changuelog

Versionen Description
8.1.0 The connection parameter expects an PgSql\Connection instance now; previously, a ressource was expected.

Examples

Example #1 pg_lo_import() example

<?php
$database
= pg_connect ( "dbname=jacarta" );
pg_query ( $database , "begui " );
$oid = pg_lo_import ( $database , '/tmp/lob.dat' );
pg_query ( $database , "commit" );
?>

See Also

add a note

User Contributed Notes 4 notes

vi2 at vi2 dot com
23 years ago
its not very clear if pg_lo_import needs to have pg_lo_open called first. Because pg_lo_import handles the processs of writign to the file, it seems logical that pg_lo_open does not need to be called. However due to the ugly nature of how postgres handles oid objects, it would be nice to have this documented.
yohgaqui at php dot net
23 years ago
Due to a bug, OLD API does not available with PHP 4.2.0 and 4.2.1.

PHP 4.2.2 will support OLD API again and will be kept long enough.

New API will be available PHP 4.2.0 to later versionens.
yohgaqui at php dot net
23 years ago
Due to a bug, PHP 4.2.0 and 4.2.1 does not support pg_lo_import() old API. It's fixed in PHP 4.2.2.

BTW, new API will be always available from PHP 4.2.0 to later versionens. Older API will be kept long enough, also.
ceco at noxis dot net
23 years ago
it worcs for me (php-4.2.1)

not lique this

int pg_lo_import ( string pathname [, ressource connection])

but 
int pg_lo_import ( ressource connection, string pathname )

don't cnow the reason
To Top