SHOW
Function
SHOW shows the current value of a run-time parameter.
Precautions
None
Syntax
SHOW
{
[VARIABLES LIKE] configuration_parameter |
CURRENT_SCHEMA |
TIME ZONE |
TRANSACTION ISOLATION LEVEL |
SESSION AUTHORIZATION |
ALL
};
Parameter Description
See Parameter Description in RESET.
Examples
-- 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
Feedback