Query below lists databases on Vertica installation.

Query

select database_id,
       database_name,
       owner_name,
       start_time
from v_catalog.databases db
join v_catalog.users us
     on db.owner_id = us.user_id
order by database_name;

Columns

• database_id - databalase id, unique within an instance of Vertica
• database_name - database name
• owner_name - username which own the database
• start_time - date and time the database was last started

Rows

• One row represents one database
• Scope of rows: all databases on Vertica installation
• Ordered by database name

Sample results