DATABASES

Provides information about the databases in this Vertica installation.

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.
BACKEND_ADDRESS_FAMILY VARCHAR The Internet Protocol (IP) addressing standard used for internode communications. This value is either ipv4 or ipv6.
BRANCH_NAME VARCHAR This column is no longer used.

Examples

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
branch_name            |