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
注意:
byteafields 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
On Fedora, install the PostgreSql PDO with yum or dnf:
$ dnf install php-pgsql php-pdo_pgsql