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: 

  • The subnet (on the public network) used by the database for import/export
  • The public address of the subnet that the Vertica native load balancing uses for load balancing
 
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