Show

title: "SHOW" description: "Display the value of a configuration parameter." menu: main: parent: 'commands'

SHOW displays the value of either a specified configuration parameter or all configuration parameters.

Syntax

SHOW [ <name> | ALL ];

Aliased configuration parameters

There are a few configuration parameters that act as aliases for other configuration parameters.

• schema: an alias for showing the first resolvable schema in search_path
• time zone: an alias for timezone

{{% include-headless "/headless/configuration-parameters" %}}

Examples

Show active cluster

SHOW cluster;

 cluster
---------
 quickstart

Show transaction isolation level

SHOW transaction_isolation;

 transaction_isolation
-----------------------
 strict serializable

Related pages

• RESET
• SET