(PHP 4, PHP 5)
pg_connect — Open a PostgreSQL connection
pg_connect() opens a connection to a
PostgreSQL database specified by the
If a second call is made to pg_connect() with
connection_string as an existing connection, the
existing connection will be returned unless you pass
The old syntax with multiple parameters $conn = pg_connect("host", "port", "options", "tty", "dbname") has been deprecated.
connection_stringcan be empty to use all default parameters, or it can contain one or more parameter settings separated by whitespace. Each parameter setting is in the form keyword = value. Spaces around the equal sign are optional. To write an empty value or a value containing spaces, surround it with single quotes, e.g., keyword = 'a value'. Single quotes and backslashes within the value must be escaped with a backslash, i.e., \' and \\.
The currently recognized parameter keywords are:
dbname(defaults to value of
requiressl(deprecated in favor of
service. Which of these arguments exist depends on your PostgreSQL version.
optionsparameter can be used to set command line parameters to be invoked by the server.
PGSQL_CONNECT_FORCE_NEWis passed, then a new connection is created, even if the
connection_stringis identical to an existing connection.
PostgreSQL connection resource on success,
FALSE on failure.
Example #1 Using pg_connect()
$dbconn = pg_connect("dbname=mary");
//connect to a database named "mary"
$dbconn2 = pg_connect("host=localhost port=5432 dbname=mary");
// connect to a database named "mary" on "localhost" at port "5432"
$dbconn3 = pg_connect("host=sheep port=5432 dbname=mary user=lamb password=foo");
//connect to a database named "mary" on the host "sheep" with a username and password
$conn_string = "host=sheep port=5432 dbname=test user=lamb password=bar";
$dbconn4 = pg_connect($conn_string);
//connect to a database named "test" on the host "sheep" with a username and password
$dbconn5 = pg_connect("host=localhost options='--client_encoding=UTF8'");
//connect to a database on "localhost" and set the command line parameter which tells the encoding is in UTF-8
- pg_pconnect() - Open a persistent PostgreSQL connection
- pg_close() - Closes a PostgreSQL connection
- pg_host() - Returns the host name associated with the connection
- pg_port() - Return the port number associated with the connection
- pg_tty() - Return the TTY name associated with the connection
- pg_options() - Get the options associated with the connection
- pg_dbname() - Get the database name