Help Center> Data Warehouse Service> Developer Guide> Setting GUC Parameters> Viewing Parameter Values
View PDF

Viewing Parameter Values

GaussDB(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: 
        1
        		 
        SHOW server_version;

        server_version indicates the database version.

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

Example

Run the following command to view the server version:

1
2
3
4
5
 
SHOW server_version;
 server_version 
----------------
 9.2.4
(1 row)
Parent topic: Setting GUC Parameters