PDO_PGSQL-DSN(3) 1 PDO_PGSQL-DSN(3)
PDO_PGSQL DSN - Connecting to PostgreSQL databases
The PDO_PGSQL Data Source Name (DSN) is composed of the following elements, delimited by spaces or semicolons:
o DSN prefix
- The DSN prefix is pgsql:.
o host - The hostname on which the database server resides.
o port - The port on which the database server is running.
o dbname - The name of the database.
o 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.
o password - The password of the user for the connection. If you specify the password in the DSN, PDO ignores the value of the pass-
word argument in the PDO constructor.
Note
The bytea fields are returned as streams.
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
PHP Documentation Group PDO_PGSQL-DSN(3)
