Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-2.x)/ SQL Reference/ SQL Syntax/ SHOW
Updated on 2025-08-19 GMT+08:00
View PDF

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

See Parameters in "RESET."

Examples

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

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

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

Helpful Links

SET and RESET

Parent topic: SQL Syntax