pg_version(3) [php man page]

PG_VERSION(3)															     PG_VERSION(3)

pg_version - Returns an array with client, protocol and server version (when available)

SYNOPSIS

       array pg_version ([resource  $connection])

DESCRIPTION

       pg_version(3)  returns  an  array  with the client, protocol and server version. Protocol and server versions are only available if PHP was
       compiled with PostgreSQL 7.4 or later.

	For more detailed server information, use pg_parameter_status(3).

PARAMETERS

	      o $connection
		- PostgreSQL database connection resource. When $connection is not present, the default connection is used. The default connection
		is the last connection made by pg_connect(3) or pg_pconnect(3).

RETURN VALUES

	Returns an array with client, protocol and server keys and values (if available). Returns FALSE on error or invalid connection.

EXAMPLES

       Example #1

	      pg_version(3) example

	      <?php
		$dbconn = pg_connect("host=localhost port=5432 dbname=mary")
		   or die("Could not connect");

		$v = pg_version($dbconn);

		echo $v['client'];
	      ?>

	      The above example will output:

	      7.4

SEE ALSO

       pg_parameter_status(3).

PHP Documentation Group 													     PG_VERSION(3)

PG_PARAMETER_STATUS(3)													    PG_PARAMETER_STATUS(3)

pg_parameter_status - Looks up a current parameter setting of the server.

SYNOPSIS

       string pg_parameter_status ([resource  $connection], string  $param_name)

DESCRIPTION

	Looks up a current parameter setting of the server.

	Certain parameter values are reported by the server automatically at connection startup or whenever their values change. pg_parameter_sta-
       tus(3) can be used to interrogate these settings. It returns the current value of a parameter if known, or FALSE if the	parameter  is  not
       known.

	Parameters  reported  as  of PostgreSQL 8.0 include server_version, server_encoding, client_encoding, is_superuser, session_authorization,
       DateStyle, TimeZone, and integer_datetimes. ( server_encoding, TimeZone, and integer_datetimes were not reported by releases  before  8.0.)
       Note that server_version, server_encoding and integer_datetimes cannot change after PostgreSQL startup.

	PostgreSQL  7.3  or lower servers do not report parameter settings, pg_parameter_status(3) includes logic to obtain values for server_ver-
       sion and client_encoding anyway. Applications are encouraged to use pg_parameter_status(3) rather than ad hoc code to determine these  val-
       ues.

       Caution

	       On  a  pre-7.4  PostgreSQL  server,  changing  client_encoding via SET after connection startup will not be reflected by pg_parame-
	      ter_status(3).

PARAMETERS

	      o $connection
		- PostgreSQL database connection resource. When $connection is not present, the default connection is used. The default connection
		is the last connection made by pg_connect(3) or pg_pconnect(3).

	      o $param_name
		-  Possible $param_name values include server_version, server_encoding, client_encoding, is_superuser, session_authorization, Dat-
		eStyle, TimeZone, and integer_datetimes.

RETURN VALUES

       A string containing the value of the parameter, FALSE on failure or invalid $param_name.

EXAMPLES

       Example #1

	      pg_parameter_status(3) example

	      <?php
		$dbconn = pg_connect("dbname=publisher") or die("Could not connect");

		echo "Server encoding: ", pg_parameter_status($dbconn, "server_encoding");
	      ?>

	      The above example will output:

	      Server encoding: SQL_ASCII

PHP Documentation Group 												    PG_PARAMETER_STATUS(3)