SHOW

Shows the value of a system configuration parameter.

Synopsis

  1. SHOW <configuration_parameter>
  3. 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:

  1. SHOW search_path;

Show the current setting of all parameters:

  1. SHOW ALL;

Compatibility

SHOW is a HAWQ extension.

See Also

SET, RESET