I note that the array element for "protocol" seemingly has no value, being reported as:
["protocol"]=> int(3)
whereas the array element for e.g. "server" is reported as (in my particular case):
["server"]=> string(5) "10.12"
A call to json_encode() however gives:
"protocol":3 and "server":"10.12"
pg_version
(PHP 5)
pg_version — Returns an array with client, protocol and server version (when available)
Опис
array pg_version
([ resource
$connection
] )pg_version() 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().
Параметри
-
connection -
PostgreSQL database connection resource. When
connectionis not present, the default connection is used. The default connection is the last connection made by pg_connect() or pg_pconnect().
Значення, що повертаються
Returns an array with client, protocol
and server keys and values (if available). Returns
FALSE on error or invalid connection.
Приклади
Приклад #1 pg_version() example
<?php
$dbconn = pg_connect("host=localhost port=5432 dbname=mary")
or die("Could not connect");
$v = pg_version($dbconn);
echo $v['client'];
?>
Наведений вище приклад виведе:
7.4
add a note
User Contributed Notes 2 notes
mgchristensen ¶
3 years ago
live627 ¶
4 years ago
Complete output off this function for me is:
array(13) {
["client"]=>
string(5) "9.6.9"
["protocol"]=>
int(3)
["server"]=>
string(4) "12.1"
["server_encoding"]=>
string(4) "UTF8"
["client_encoding"]=>
string(4) "UTF8"
["is_superuser"]=>
string(2) "on"
["session_authorization"]=>
string(8) "postgres"
["DateStyle"]=>
string(8) "ISO, MDY"
["IntervalStyle"]=>
string(8) "postgres"
["TimeZone"]=>
string(10) "US/Arizona"
["integer_datetimes"]=>
string(2) "on"
["standard_conforming_strings"]=>
string(2) "on"
["application_name"]=>
string(0) ""
}
