​
Overview

The pg_settings displays the configuration settings for the current session. It mimics the pg_settings PostgreSQL system catalog.

​
Columns

This table is designed for compatibility with tools that require PostgreSQL system tables, so it mostly has dummy data. Please note that not all columns in pg_settings are applicable to every type of relation.
The following columns are available for querying in pg_settings:
ColumnTypeDescription
nametextThis column represents the run-time configuration parameter name
settingtextThis column represents the current value of the parameter
unittextUnused.
categorytextUnused.
short_desctextUnused.
extra_desctextUnused.
contexttextUnused.
vartypetextUnused.
sourcetextUnused.
min_valtextUnused.
max_valtextUnused.
enumvalstextUnused.
boot_valtextUnused.
reset_valtextUnused.
sourcefiletextUnused.
sourcelineintUnused.
pending_restartboolUnused.

​
Example

To retrieve information from the pg_settings catalog, you can execute a query like: 
SELECT name, setting FROM pg_settings;
You will get the run-time configuration values as shown below. 
     name      | setting 
----------------+---------
 max_index_keys | 32