How to connect to the Vertica database using the admintools command line

Using the admintools command line we can create all types of routines and scripts.

  • How to connect to the Vertica database using the admintools command line:
  • For this task you need to use the connect_db option followed by the credentials

    [dbadmin@bih001 ~]$ admintools -t connect_db -d test -p test
    Welcome to vsql, the Vertica Analytic Database interactive terminal.
    
    Type:  h or ? for help with vsql commands
           g or terminate with semicolon to execute query
           q to quit
    
    test=>