PDO_PGSQL DSN
(PHP 5 >= 5.1.0, PHP 7, PECL PDO_PGSQL >= 0.1.0)
PDO_PGSQL DSN — Connecting to PostgreSQL databases
Description
The PDO_PGSQL Data Source Name (DSN) is composed of the following elements, delimited by spaces or semicolons:
- 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.
-
sslmode
-
The SSL mode. Supported values and their meaning are listed in the » PostgreSQL Documentation.
Note: All semicolons in the DSN string are replaced by spaces, because PostgreSQL expects this format. This implies that semicolons in any of the components (e.g.
password
ordbname
) are not supported.
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