• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. Setting Configuration Parameters
  5. Viewing Parameter Values

Viewing Parameter Values

DWS uses a set of default GUC parameters after it is installed. You can modify the parameters to better fit your service scenario and data volume.

Procedure

  1. View the parameter values of a database.

    • Use the SHOW command.
      • To view a certain parameter, run the following command:
        SHOW server_version;

        server_version indicates the database version.

      • Run the following command to view values of all parameters:
        SHOW ALL;
    • Use the pg_settings view.
      • To view a certain parameter, run the following command:
        SELECT * FROM pg_settings WHERE NAME='server_version';
      • Run the following command to view values of all parameters:
        SELECT * FROM pg_settings;

Example

Run the following command to view the server version:

SHOW server_version;
 server_version 
----------------
 9.2.4
(1 row)