YMatrix
Quick Start
Connecting
Benchmarks
Deployment
Data Usage
Manage Clusters
Upgrade
Global Maintenance
Expansion
Monitoring
Security
Best Practice
Technical Principles
Data Type
Storage Engine
Execution Engine
Streaming Engine(Domino)
MARS3 Index
Extension
Advanced Features
Advanced Query
Federal Query
Grafana
Backup and Restore
Disaster Recovery
Guide
Performance Tuning
Troubleshooting
Tools
Configuration Parameters
SQL Reference
Displays the value of the system configuration parameters.
SHOW configuration_parameter
SHOW ALLSHOW displays the current settings for the YMatrix database system configuration parameters. You can set these parameters using SET statements or by editing the postgresql.conf configuration file of the YMatrix database master. Note that some of the parameters that SHOW can view are read-only - they can be viewed but cannot be set. For more information, see the YMatrix Database Reference Guide.
configuration_parameter
ALL
Display the current settings of the parameter DateStyle:
SHOW DateStyle;
DateStyle
--------------
ISO, MDY
(1 row)Display the current settings of parameter geqo:
SHOW geqo;
geqo
------
off
(1 row)Shows the current settings for all parameters:
SHOW ALL;
name | setting | description
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
application_name | psql | Sets the application name to be reported in sta...
.
.
.
xmlbinary | base64 | Sets how binary values are to be encoded in XML.
xmloption | content | Sets whether XML data in implicit parsing and s...
(331 rows)SHOW is a YMatrix database extension.