PostgreSQL Functions (PDO_PGSQL)
Introduction
PDO_PGSQL is a driver that implements the PHP Data Objects (PDO) interface to enable access from PHP to PostgreSQL databases.
Resource Types
This extension defines a stream resource returned by PDO::pgsqlLOBOpen().
Installation
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
Predefined Constants
The constants below are defined by
this driver, and will only be available when the extension has been either
compiled into PHP or dynamically loaded at runtime. In addition, these
driver-specific constants should only be used if you are using this driver.
Using driver-specific attributes with another driver may result in
unexpected behaviour. PDO::getAttribute() may be used to
obtain the PDO::ATTR_DRIVER_NAME
attribute to check the
driver, if your code can run against multiple drivers.
-
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
Note:
bytea
fields are returned as streams.
Table of Contents
- 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