Updated on 2025-02-27 GMT+08:00
SHOW
Description
SHOW shows the current value of a GUC parameter.
Syntax
SHOW { [VARIABLES LIKE] configuration_parameter | CURRENT_SCHEMA | TIME ZONE | TRANSACTION ISOLATION LEVEL | SESSION AUTHORIZATION | ALL };
Parameters
See Parameters 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;
Parent topic: SQL Syntax
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
The system is busy. Please try again later.
For any further questions, feel free to contact us through the chatbot.
Chatbot