Vertica Quick Tip: Using vsql Almost Anywhere

Posted May 8, 2018 by Soniya Shah, Information Developer

This blog post was authored by Jim Knicely. I’m an old school kind of guy so I love our vsql command line interface (CLI) tool. What’s cool is if I am on a remote Linux host, I can copy the vsql binary from the database host and run then run it locally. Example: [dbadmin@s18384357 ~]$ vsql -bash: vsql: command not found [dbadmin@s18384357 ~]$ scp /usr/bin vsql [dbadmin@s18384357 ~]$ vsql -h 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 dbadmin=> Have Fun!