SHOW
Display the current value of a session variable.
Syntax
SHOW ALL displays all variables with their values and descriptions.
Examples
SHOW search_path;
search_path
-----------------
"$user", public
SHOW transaction_isolation;
transaction_isolation
-----------------------
repeatable read
SHOW ALL;