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