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	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.