pg_settings

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:

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