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

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)