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.

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=>