Skip to main content

List of available databases from a Vertica database

  • July 29, 2015
  • 2 replies
  • 20 views
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.

 

 

    2 replies

    SruthiA
    Forum|alt.badge.img+1
    • SruthiA
    • Participating Frequently
    • July 29, 2015

    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
    • Vertica_grm
    • Author
    • New Participant
    • July 29, 2015

    Thanks Sruthi!

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement