# 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