Help Center > > Developer Guide> Setting GUC Parameters> Viewing Parameter Values

Viewing Parameter Values

Updated at: Mar 13, 2020 GMT+08:00

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)

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel