pg_connect

(PHP3 , PHP4 )

pg_connect -- Open a PostgreSQL connection

Description

int pg_connect (string conn_string)

Returns a connection index on success, or false if the connection could not be made. Opens a connection to a PostgreSQL database. The arguments should be within a quoted string.

Example 1. Using pg_connect arguments


<?php
$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 ("user=lamb passwd=baaaa dbname=mary ");
//connect to a database named "mary" with a username and password
?>
     
The arguments available include dbname port, host, tty, options, user, and password

This function returns a connection index that is needed by other PostgreSQL functions. You can have multiple connections open at once.

The previous syntax of: $conn = pg_connect ("host", "port", "options", "tty", "dbname") has been deprecated.

See also pg_pconnect().