SHOW DATABASE
Displays configuration parameter values that are set for the database. If a configuration parameter is not set at the database level, SHOW DATABASE
does not return a row for that parameter. If the configuration parameter requires a restart to take effect, the values shown might differ from the active values.
Syntax
SHOW DATABASE db‑name { parameter‑name[,...] | ALL }
Parameters
db‑name | Name of database for which to show the parameter values. |
parameter‑name | Names of any configuration parameters you want to show. |
ALL
|
Shows all configuration parameters set at the database level. |
Privileges
- Superusers only
- Non-superusers:
SHOW DATABASE ALL
returns masked parameter settings. Attempts to view specific parameter settings return an error.
Examples
Show all configuration parameters that are set at the database level:
=> SHOW DATABASE VMart ALL; name | setting -------------------------+------------------------ AnalyzeRowCountInterval | 3600 DefaultSessionLocale | en_US@collation=binary JavaBinaryForUDx | /usr/bin/java (3 rows)