System Catalogs
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