SHOW SESSION
Displays set configuration parameter values for the current session. If the configuration parameter is not set at the session level,SHOW SESSION
does not return a row for that parameter. If the configuration parameter requires a restart to take effect, the values shown might differ from the active values.
Syntax
SHOW SESSION { parameter‑name[,...]| ALL }
Parameters
parameter‑name |
Names of any configuration parameters you want to show. |
ALL
|
Shows all configuration parameters set at the session level. |
Privileges
- Superusers only
- Non-superusers:
SHOW CURRENT ALL
returns masked parameter settings. Attempts to view specific parameter settings return an error.
Examples
View all configuration parameters and their settings for the current session:
=> SHOW SESSION ALL:
name | setting ----------------------------+--------------------------------------------------- locale | en_US@collation=binary (LEN_KBINARY) autocommit | off standard_conforming_strings | on escape_string_warning | on datestyle | ISO, MDY intervalstyle | plain timezone | America/New_York search_path | "$user", public, v_catalog, v_monitor, v_internal transaction_isolation | READ COMMITTED transaction_read_only | false resource_pool | general memorycap | UNLIMITED tempspacecap | UNLIMITED runtimecap | UNLIMITED enabled roles | dbduser*, dbadmin*, pseudosuperuser* available roles | dbduser*, dbadmin*, pseudosuperuser* ForceUDxFencedMode | 1 (17 rows)