• 首页
  • vue
  • TypeScript
  • JavaScript
  • scss
  • css3
  • html5
  • php
  • MySQL
  • redis
  • jQuery
  • pg_lo_export()

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

    将大型对象导出到文件

    说明

    pg_lo_export([resource $connection],int $oid,string $pathname): bool

    pg_lo_export() takes a large object in a PostgreSQL database and saves its contents to a file on the local filesystem.

    要使用大型对象(lo)接口,需要将其放置在事务块中。

    Note:

    本函数以前的名字为pg_loexport()

    参数

    $connection

    PostgreSQL database connection resource. When$connectionis not present, the default connection is used. The default connection is the last connection made by pg_connect() or pg_pconnect().

    $oid

    要导出的数据库里的大型对象的OID

    $pathname

    要导出的数据库里的大型对象的文件在客户端上完整路径和文件名。

    返回值

    成功时返回TRUE,或者在失败时返回FALSE

    范例

    Example #1 pg_lo_export() 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_create()

    下篇:pg_lo_import()