List of available databases from a Vertica database

Vertica_grm

I'm looking for a select statement which gives me  list of available databases from a Vertica database based on user login credentials.

 

 

SruthiA

Hi,

 

   The following URL contains information regarding the system table "databases". It provides information about the databases in current HP Vertica installation.

 

https://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/SQLReferenceManual/SystemTables/CATALOG/DATABASES.htm%3FTocPath%3DSQL%2520Reference%2520Manual%7CHP%2520Vertica%2520System%2520Tables%7CV_CATALOG%2520Schema%7C_____9

 

 

-Regards,

 Sruthi 

Vertica_grm

Thanks Sruthi!