HomeMogDBMogDB StackUqbar
v3.1

Documentation:v3.1

Supported Versions:

PG_SETTINGS

PG_SETTINGS displays information about parameters of the running database.

Table 1 PG_SETTINGS columns

Name Type Description
name text Parameter name
setting text Current parameter value
unit text Implicit unit of the parameter
category text Logical group of the parameter
short_desc text Brief description of the parameter
extra_desc text Detailed description of the parameter
context text Context required to set the parameter value, including internal, postmaster, sighup, backend, superuser, and user
vartype text Parameter type, including bool, enum, integer, real, or string
source text Method of assigning the parameter value
min_val text Minimum value of the parameter. If the parameter type is not numeric, the value of this column is null.
max_val text Maximum value of the parameter. If the parameter type is not numeric, the value of this column is null.
enumvals text[] Valid values of an enum-type parameter. If the parameter type is not enum, the value of this column is null.
boot_val text Default parameter value used upon the database startup
reset_val text Default parameter value used upon the database reset
sourcefile text Configuration file used to set parameter values. If parameter values are not configured using the configuration file, the value of this column is null.
sourceline integer Row number of the configuration file for setting parameter values. If parameter values are not configured using the configuration file, the value of this column is null.
Copyright © 2011-2024 www.enmotech.com All rights reserved.