PostgreSQL PDO Driver (PDO_PGSQL)

Introduzione

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

Tipi di risorse

This extension defines a stream resource returned by Pdo\Pgsql::lobOpen().

Installazione

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

Costanti predefinite

Le costanti qui sotto sono definite da questo driver, e sono disponibili solo quanto l'estensione è stata o compilata nel PHP o caricata dinamicamente a runtime. In aggiunta, queste costanti specifiche del driver dovrebbero essere usate solo se si sta usando il driver stesso. Utilizzare attributi specifici di mysql con il driver postgres può portare a risultati imprevedibili. PDO::getAttribute() può essere usata per ottenere l'attributo PDO_ATTR_DRIVER_NAME per identificare il driver, se il codice può funzionare con driver differenti.

PDO::PGSQL_ATTR_DISABLE_PREPARES (int)

Alias di Pdo\Pgsql::ATTR_DISABLE_PREPARES. As of PHP 8.5.0, this constant is deprecated.

PDO::PGSQL_TRANSACTION_IDLE (int)

Equivalent to Pdo\Pgsql::TRANSACTION_IDLE. As of PHP 8.5.0, this constant is deprecated, as it has no effect.

PDO::PGSQL_TRANSACTION_ACTIVE (int)

Equivalent to Pdo\Pgsql::TRANSACTION_ACTIVE. As of PHP 8.5.0, this constant is deprecated, as it has no effect.

PDO::PGSQL_TRANSACTION_INTRANS (int)

Equivalent to Pdo\Pgsql::TRANSACTION_INTRANS. As of PHP 8.5.0, this constant is deprecated, as it has no effect.

PDO::PGSQL_TRANSACTION_INERROR (int)

Equivalent to Pdo\Pgsql::TRANSACTION_INERROR. As of PHP 8.5.0, this constant is deprecated, as it has no effect.

PDO::PGSQL_TRANSACTION_UNKNOWN (int)

Equivalent to Pdo\Pgsql::TRANSACTION_UNKNOWN. As of PHP 8.5.0, this constant is deprecated, as it has no effect.

General notes

Nota: bytea columns are returned as stream resources. See Large Objects (LOBs) for how to read these values and how to bind data with PDO::PARAM_LOB.