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

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)