pg_parameter_status — Get the value of a parameter from the database server
pg_parameter_statusconn
paramName
pg_parameter_status
returns the value of a
PostgreSQL parameter as supplied by the server.
Different releases of PostgreSQL may provide different parameters.
As of PostgreSQL-8.1.4, the following parameters are available.
Parameter | Description | Example Value |
---|---|---|
client_encoding | Client's character set encoding | SQL_ASCII |
DateStyle | Display format and rules for ambiguous date/time values | ISO, MDY |
integer_datetimes | Date/times are integer based | off |
is_superuser | Has superuser rights? | off |
standard_conforming_strings | Backslash \ is literal in quoted strings | off |
server_encoding | Server (database) character set encoding | SQL_ASCII |
server_version | PostgreSQL server version | 8.1.4 |
session_authorization | Username | guest |
TimeZone | Time zone for displaying and interpreting time stamps | EST5EDT |
conn
The handle of the connection.
paramName
The name of the parameter to get. See above list.