pg_settings

Overview

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

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:

Column	Type	Description
name	text	This column represents the run-time configuration parameter name
setting	text	This column represents the current value of the parameter
unit	text	Unused.
category	text	Unused.
short_desc	text	Unused.
extra_desc	text	Unused.
context	text	Unused.
vartype	text	Unused.
source	text	Unused.
min_val	text	Unused.
max_val	text	Unused.
enumvals	text	Unused.
boot_val	text	Unused.
reset_val	text	Unused.
sourcefile	text	Unused.
sourceline	int	Unused.
pending_restart	bool	Unused.

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