SHOW DATABASE
Displays configuration parameter values that are set for the database.
If the configuration parameter is set but requires a database restart to take effect, the value shown might differ from the active value.
Syntax
SHOW DATABASE db‑spec { parameter‑name[,…] | ALL }
Parameters
db‑spec |
Specifies the current database, set to the database name or |
parameter‑name |
Names of one or more configuration parameters to show.
Non-superusers can only specify parameters whose settings are not masked by If you specify a single parameter that is not set, To obtain the names of database-level parameters, query system table |
ALL
|
Shows all configuration parameters set at the database level. For non-superusers, Vertica masks settings of security parameters, which only superusers can access. |
Privileges
- Superuser: Shows all database parameter settings.
- Non-superuser: Masks all security parameter settings, which only superusers can access. To determine which parameters require superuser privileges, query system table
CONFIGURATION_PARAMETERS
.
Examples
Show to a non-superuser all configuration parameters that are set on the database:
=> SHOW DATABASE DEFAULT ALL; name | setting --------------------------------+---------- AllowNumericOverflow | 1 CopyFaultTolerantExpressions | 1 EnableSSL | 1 GlobalHeirUsername | ******** MaxClientSessions | 50 NumericSumExtraPrecisionDigits | 0 (6 rows)
Show settings for two configuration parameters:
=> SHOW DATABASE DEFAULT AllowNumericOverflow, NumericSumExtraPrecisionDigits; name | setting --------------------------------+--------- AllowNumericOverflow | 1 NumericSumExtraPrecisionDigits | 0 (2 rows)