The pg_settings
displays the configuration settings for the current session. It mimics the pg_settings PostgreSQL system catalog.
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. |
To retrieve information from the pg_settings catalog, you can execute a query like:
You will get the run-time configuration values as shown below.
The pg_settings
displays the configuration settings for the current session. It mimics the pg_settings PostgreSQL system catalog.
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. |
To retrieve information from the pg_settings catalog, you can execute a query like:
You will get the run-time configuration values as shown below.