Help Center/ GaussDB/ M-Compatibility Developer Guide(Distributed)/ SQL Reference/ SQL Syntax/ SQL Statements/ S/ SHOW
Updated on 2025-10-23 GMT+08:00
View PDF
Share

SHOW

Description

SHOW shows the current value of a GUC parameter.

Syntax

SHOW 
  { 
    [VARIABLES LIKE] configuration_parameter | 
    TIME ZONE | 
    TRANSACTION ISOLATION LEVEL | 
    SESSION AUTHORIZATION | 
    ALL
  };

SHOW [DATABASES | SCHEMAS] [like_or_where]

like_or_where: 
  {
    LIKE 'pattern' |
    WHERE expr
  };

Parameters

  • configuration_parameter

    Specifies the name of the GUC parameter.

    Value range: GUC parameters. You can view the GUC parameters by using the SHOW ALL statement.

    SHOW CHARSET, SHOW COLLATION, and SHOW PROCESSLIST are not supported.

  • TIME ZONE

    Specifies the time zone.

  • TRANSACTION ISOLATION LEVEL

    Specifies the transaction isolation level.

  • SESSION AUTHORIZATION

    Specifies the user identifier of the current session.

  • DATABASES | SCHEMAS

    Specifies all schemas in the current database.

  • ALL

    Specifies all GUC parameters.

SHOW syntax examples

-- Show the value of timezone.
m_db=# SHOW timezone;

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

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

Helpful Links

SET and RESET

Parent topic: S