Updated on 2025-05-29 GMT+08:00

SHOW

Description

SHOW shows the current value of a GUC parameter.

Syntax

1
2
3
4
5
6
7
8
9
SHOW 
  { 
    [VARIABLES LIKE] configuration_parameter | 
    CURRENT_SCHEMA | 
    TIME ZONE | 
    TRANSACTION ISOLATION LEVEL | 
    SESSION AUTHORIZATION | 
    ALL 
  };

Parameters

  • configuration_parameter

    Specifies the name of a GUC parameter.

    Value range: GUC parameters. You can view them by running the SHOW ALL command.

    Some parameters viewed by running SHOW ALL cannot be set by running SET, for example, max_datanodes.

  • CURRENT_SCHEMA

    Specifies the current schema.

  • TIME ZONE

    Specifies the time zone.

  • TRANSACTION ISOLATION LEVEL

    Specifies the transaction isolation level.

  • SESSION AUTHORIZATION

    Specifies the session authorization.

  • ALL

    Specifies all GUC parameters.

Examples

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
-- Show the value of timezone.
gaussdb=# SHOW timezone;
TimeZone 
----------
 PRC
(1 row)

-- Show the current schema.
gaussdb=# SHOW CURRENT_SCHEMA;
 current_schema 
----------------
 "$user",public
(1 row)

-- Show the isolation level of a transaction.
gaussdb=# SHOW TRANSACTION ISOLATION LEVEL;
 transaction_isolation 
-----------------------
 read committed
(1 row)

-- Show the user identifier of the current session.
gaussdb=# SHOW SESSION AUTHORIZATION;
 session_authorization 
-----------------------
 omm1
(1 row)

-- Show all parameters.
gaussdb=# SHOW ALL;

-- Show all parameters whose names contain var.
gaussdb=# SHOW VARIABLES LIKE var;

Helpful Links

SET and RESET