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 |
Can be either of the following:
|
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. |
BACKEND_ADDRESS_FAMILY | VARCHAR | The Internet Protocol (IP) addressing standard used for internode communications. Use Internet Protocol version 4 (IPv4). |
Example
This example queries the databases table from a master database.
=> SELECT * FROM DATABASES;
-[ RECORD 1 ]----------+-------------------------------------------------------------
database_id | 45035996273704976
database_name | VMart
owner_id | 45035996273704962
owner_name | dbadmin
start_time | 2017-10-22 05:16:22.066961-04
compliance_message | The database is in compliance with respect to raw data size.
export_subnet | 0
load_balance_policy | none
backend_address_family | ipv4