PostgreSQL Functions (PDO_PGSQL)

简介

PDO_PGSQL is a driver that implements the PHP Data Objects (PDO) interface to enable access from PHP to PostgreSQL databases.

资源类型

This extension defines a stream resource returned by PDO::pgsqlLOBOpen().

安装

Use --with-pdo-pgsql[=DIR] to install the PDO PostgreSQL extension, where the optional [=DIR] is the PostgreSQL base install directory, or the path to pg_config.

$ ./configure --with-pdo-pgsql

预定义常量

下列常量由此驱动定义，且仅在扩展编译入 PHP 或在运行时动态载入时可用。另外，使用此驱动时，仅会使用这些驱动特定的常量。使用其他驱动的驱动特定的常量可能会导致不可预见的情况。如果代码可运行于多个驱动，PDO::getAttribute() 可被用于获取 PDO_ATTR_DRIVER_NAME 属性以检查驱动。

PDO::PGSQL_ATTR_DISABLE_PREPARES (int): Send the query and the parameters to the server together in a single call, avoiding the need to create a named prepared statement separately. If the query is only going to be executed once this can reduce latency by avoiding an unnecessary server round-trip.

General notes

注意:
bytea fields are returned as streams.

PDO_PGSQL DSN — Connecting to PostgreSQL databases
PDO::pgsqlCopyFromArray — Copy data from PHP array into table
PDO::pgsqlCopyFromFile — Copy data from file into table
PDO::pgsqlCopyToArray — Copy data from database table into PHP array
PDO::pgsqlCopyToFile — Copy data from table into file
PDO::pgsqlGetNotify — Get asynchronous notification
PDO::pgsqlGetPid — Get the server PID
PDO::pgsqlLOBCreate — Creates a new large object
PDO::pgsqlLOBOpen — Opens an existing large object stream
PDO::pgsqlLOBUnlink — Deletes the large object

add a note

User Contributed Notes 1 note

down

-21

rtroy at sciencetools dot com ¶

3 years ago


On Fedora, install the PostgreSql PDO with yum or dnf:

   $ dnf install php-pgsql php-pdo_pgsql