pg_parameter_status

(PHP 5, PHP 7)

pg_parameter_status — Looks up a current parameter setting of the server

说明

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

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_status() 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() includes logic to obtain values for server_version and client_encoding anyway. Applications are encouraged to use pg_parameter_status() rather than ad hoc code to determine these values.

Caution

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

参数

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() or pg_pconnect().

param_name

Possible param_name values include server_version, server_encoding, client_encoding, is_superuser, session_authorization, DateStyle, TimeZone, and integer_datetimes.

返回值

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

范例

Example #1 pg_parameter_status() example

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

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

以上例程会输出：

Server encoding: SQL_ASCII

相关文章
php apd 函数 changes or sets the current debugging levelphp php 选项/信息 函数 returns the current process titlephp cubrid mysql 兼容性函数 return the current cubrid connection charsetphp ftp 函数 append the contents of a file to another file on the ftp serverphp ncurses 函数 delete line at current position move rest of screen upphp ncurses 函数 insert lines before current line scrolling down negative numbers delete and scroll up php ncurses 函数 scroll window content up or down without changing current positionphp postgresql 函数 looks up a current parameter setting of the serverphp postgresql 函数 submits a command to the server and waits for the result with the ability to pass parameters separately from the sql command textphp postgresql 函数 submits a command and separate parameters to the server without waiting for the result s php postgresql 函数 returns the current in transaction status of the serverphp postgresql 函数 returns an array with client protocol and server version when available php sqlsrv 函数 opens a connection to a microsoft sql server databasephp sqlsrv 函数 sends data from parameter streams to the serverphp ssh2 函数 close a connection to a remote ssh serverphp statistic 函数 calculates any one parameter of the gamma distribution given values for the othersphp stomp 函数 gets the current stomp extension versionphp stream 函数 接受由 stream socket server 创建的套接字连接php xmlwriter 函数 end current documentphp yaz 函数 prepares for a connection to a z39.50 server
关注编程学问公众号