Home > PHP > Function > PostgreSQL > pg_connect()

pg_connect()

pg_connect - Open a PostgreSQL connection

Syntax

resource pg_connect (string $connection_string, int $connect_type)

Arguments

  • connection_string - The connection_string can 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: host, hostaddr, port, dbname, user, password, connect_timeout, options, tty (ignored), sslmode, requiressl (deprecated in favor of sslmode), and service. Which of these arguments exist depends on your PostgreSQL version.
  • connect_type - If PGSQL_CONNECT_FORCE_NEW is passed, then a new connection is created, even if the connection_string is identical to an existing connection.

Description

pg_connect() opens a connection to a PostgreSQL database specified by the connection_string.

Version

PHP 4, 5

Return value

PostgreSQL connection resource on success, FALSE on failure.