PHP Manual
Prev |  | Next

# PDO_PGSQL DSN

(no version information, might be only in CVS)

PDO_PGSQL DSN -- Connecting to PostgreSQL databases

## Description

The PDO_PGSQL Data Source Name (DSN) is composed of the following elements, delimited by spaces:

DSN prefix

  The DSN prefix is `pgsql:`.

`host`

  The hostname on which the database server resides.

`port`

  The port on which the database server is running.

`dbname`

  The name of the database.

`user`

  The name of the user for the connection. If you specify the user name in the DSN, PDO ignores the value of the user name argument in the PDO constructor.

`password`

  The password of the user for the connection. If you specify the password in the DSN, PDO ignores the value of the password argument in the PDO constructor.

## Examples

Example 1. PDO_PGSQL DSN examples The following example shows a PDO_PGSQL DSN for connecting to a PostgreSQL database:
    pgsql:host=localhost port=5432 dbname=testdb user=bruce password=mypass

Prev | Home | Next
PostgreSQL Functions (PDO_PGSQL) | Up | PDO::pgsqlLOBCreate