List databases on a Vertica installation

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

0
There are no comments. Click here to write the first comment.