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
- configuration_parameter
Specifies the name of a GUC parameter.
Value range: GUC parameters. You can view them by running the SHOW ALL command.
Some parameters viewed by running SHOW ALL cannot be set by running SET, for example, max_datanodes.
- CURRENT_SCHEMA
Specifies the current schema.
- TIME ZONE
Specifies the time zone.
- TRANSACTION ISOLATION LEVEL
Specifies the transaction isolation level.
- SESSION AUTHORIZATION
Specifies the session authorization.
- ALL
Specifies all GUC parameters.
Examples
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 |
-- Show the value of timezone. gaussdb=# SHOW timezone; TimeZone ---------- PRC (1 row) -- Show the current schema. gaussdb=# SHOW CURRENT_SCHEMA; current_schema ---------------- "$user",public (1 row) -- Show the isolation level of a transaction. gaussdb=# SHOW TRANSACTION ISOLATION LEVEL; transaction_isolation ----------------------- read committed (1 row) -- Show the user identifier of the current session. gaussdb=# SHOW SESSION AUTHORIZATION; session_authorization ----------------------- omm1 (1 row) -- Show all parameters. gaussdb=# SHOW ALL; -- Show all parameters whose names contain var. gaussdb=# SHOW VARIABLES LIKE var; |
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.
For any further questions, feel free to contact us through the chatbot.
Chatbot