Viewing Parameters
GaussDB uses a set of default GUC parameters after it is installed. You can modify the GUC parameters to enable GaussDB to better fit your service scenarios and data volume.
Procedure
- Connect to the database. For details, see "Database Quick Start > Connecting to a Database > Using gsql to Connect to a Database" in Developer Guide.
- View the GUC parameter values in the database.
- Method 1: Run the SHOW command.
- View the value of a certain parameter.
1
gaussdb=# SHOW server_version;
server_version indicates the database version.
- View values of all parameters.
1
gaussdb=# SHOW ALL;
- View the value of a certain parameter.
- Method 2: Query the pg_settings view.
- View the value of a certain parameter.
1
gaussdb=# SELECT * FROM pg_settings WHERE NAME='server_version';
- View values of all parameters.
1
gaussdb=# SELECT * FROM pg_settings;
- View the value of a certain parameter.
- Method 1: Run the SHOW command.
Example
Check the character encoding type of the client.
1 2 3 4 5 |
gaussdb=# SHOW client_encoding; client_encoding ---------------- UTF8 (1 row) |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot