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

<configuration_parameter>
The name of a system configuration parameter.

ALL
Shows the current value of all configuration 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.

See Also

SET, RESET