SHOW

Shows run-time parameters for the current session.

Syntax

SHOW { parameter | ALL }

Parameters

`AUTOCOMMIT`	Shows whether statements automatically commit their transactions when they complete.
`AVAILABLE_ROLES`	Lists all roles available to the user.
`DATESTYLE`	Shows the current style of date values. See SET DATESTYLE.
`ENABLED_ROLES`	Shows the roles enabled for the current session. See SET ROLE.
`ESCAPE_STRING_WARNING`	Shows whether warnings are issued when backslash escapes are found in strings. See SET ESCAPE_STRING_WARNING.
`IDLESESSIONTIMEOUT`	Specifies how long the session can remain idle before it times out.
`INTERVALSTYLE`	Shows whether units are output when printing intervals. See SET INTERVALSTYLE.
`LOCALE`	Shows the current locale. See SET LOCALE.
`MEMORYCAP`	Shows the maximum amount of memory that any request use. See SET MEMORYCAP.
`MULTIPLEACTIVERESULTSETS`	Shows whether multiple active result sets on one connection are allowed. See SET SESSION MULTIPLEACTIVERESULTSETS
`RESOURCE_POOL`	Shows the resource pool that the session is using. See SET RESOURCE POOL.
`RUNTIMECAP`	Shows the maximum amount of time that queries can run in the session. See SET RUNTIMECAP
`SEARCH_PATH`	Shows the order in which Vertica searches schemas. See SET SEARCH_PATH.
`STANDARD_CONFORMING_STRINGS`	Shows whether backslash escapes are enabled for the session. See SET STANDARD_CONFORMING_STRINGS.
`TEMPSPACECAP`	Shows the maximum amount of temporary file space that queries can use in the session. See SET TEMPSPACECAP.
`TIMEZONE`	Shows the timezone set in the current session. See SET TIMEZONE.
`TRANSACTION_ISOLATION`	Shows the current transaction isolation setting, as described in SET SESSION CHARACTERISTICS AS TRANSACTION.
`TRANSACTION_READ_ONLY`	Shows the current read-only setting, as described in SET SESSION CHARACTERISTICS AS TRANSACTION.
`ALL`	Shows all run-time settings.

Privileges

None

Examples

Display all current runtime parameter settings:

=> SHOW 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                    | US/Eastern
 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               |
 available roles             | applogs, appadmin
(15 rows)

Return current search path settings:

=> SHOW SEARCH_PATH;
    name     |                      setting
-------------+---------------------------------------------------
 search_path | "$user", public, v_catalog, v_monitor, v_internal
(1 row)

Show the session's transaction isolation level:

=> SHOW TRANSACTION_ISOLATION;
         name          |    setting
-----------------------+----------------
 transaction_isolation | READ COMMITTED
(1 row)

Return the current transaction isolation level, as set by SET SESSION CHARACTERISTICS AS TRANSACTION. False indicates that the default read/write setting is in effect:

=> SHOW TRANSACTION_READ_ONLY;
         name          | setting
-----------------------+---------
 transaction_read_only | false
(1 row)

To change to read only:

=> SET SESSION CHARACTERISTICS AS TRANSACTION READ ONLY;

The same SHOW command now returns true:

=> SHOW TRANSACTION_READ_ONLY;
         name          | setting
-----------------------+---------
 transaction_read_only | true
(1 row)