Vertica Quick Tip: Using vsql Almost Anywhere

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 verticademos.com:/opt/vertica/bin/vsql /usr/bin vsql [dbadmin@s18384357 ~]$ vsql -h verticademos.com 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!