# PDO_PGSQL DSN

(No version information available, 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.

> Note: The bytea fields are returned as streams.

### 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