SHOW
Shows the value of a system configuration parameter.
Synopsis
SHOW <configuration_parameter>
SHOW ALL
Description
SHOW displays the current settings of HAWQ system configuration parameters. These parameters can be set using the SET statement, or by editing the hawq-site.xml configuration file of the HAWQ master. Note that some parameters viewable by SHOW are read-only — their values can be viewed but not set. See About Server Configuration Parameters.
Parameters
Examples
Show the current setting of the parameter search_path:
SHOW search_path;
Show the current setting of all parameters:
SHOW ALL;
Compatibility
SHOW is a HAWQ extension.