Php/docs/ref.pdo-pgsql

• PHP Manual
• PDO Drivers
• 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

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