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.