Updated on 2024-05-07 GMT+08:00

SHOW

Function

Shows the current value of a run-time parameter.

Precautions

None

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 
  };

Parameter Description

See Parameters in RESET.

Examples

1
2
3
4
5
6
7
8
-- Show the value of timezone.
gaussdb=# SHOW timezone;

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

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

Helpful Links

SET and RESET