show.md 883 B


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

{{% configuration-parameters %}}

Examples

Show active cluster

SHOW cluster;
 cluster
---------
 quickstart

Show transaction isolation level

SHOW transaction_isolation;
 transaction_isolation
-----------------------
 strict serializable

Related pages