DATABASES
Provides information about the databases in this Vertica installation.
Column Name | Data Type | Description |
---|---|---|
DATABASE_ID |
INTEGER |
The database's internal ID number |
DATABASE_NAME |
VARCHAR |
The database's name |
OWNER_ID |
INTEGER |
The database owner's ID |
OWNER_NAME |
INTEGER |
The database owner's name |
START_TIME |
TIMESTAMPTZ |
The date and time the database last started |
COMPLIANCE_MESSAGE |
VARCHAR |
Message describing the current state of the database's license compliance. |
EXPORT_SUBNET |
VARCHAR |
The subnet (on the public network) used by the database for import/export. |
LOAD_BALANCE_POLICY |
VARCHAR | The current native connection load balance policy, which controls whether client connection requests are redirected to other hosts in the database. See About Native Connection Load Balancing in the Administrator's Guide. |