Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Using vsql Almost Anywhere

SarahLSarahL Administrator
edited May 2018 in Tips from the Team

Jim Knicely authored this tip.

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.


[[email protected] ~]$ vsql
-bash: vsql: command not found

[[email protected] ~]$ scp /usr/bin

[[email protected] ~]$ 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


Have Fun!


  • Jim_KnicelyJim_Knicely Administrator

    Note that the vsql CLI does have some several dependencies:

    [[email protected] ~]$ ldd /opt/vertica/bin/vsql
   =>  (0x00007fff2773c000)
   => /lib64/ (0x00007fad2f594000)
   => /lib64/ (0x00007fad2f354000)
   => /lib64/ (0x00007fad2f134000)
   => /lib64/ (0x00007fad2ef14000)
   => /lib64/ (0x00007fad2ed0c000)
   => /opt/vertica/lib/ (0x00007fad2ea9c000)
   => /opt/vertica/lib/ (0x00007fad2e6b4000)
   => /usr/lib64/ (0x00007fad2e3a4000)
   => /lib64/ (0x00007fad2e11c000)
   => /lib64/ (0x00007fad2defc000)
   => /lib64/ (0x00007fad2db64000)
            /lib64/ (0x00007fad2f7b4000)
   => /lib64/ (0x00007fad2d95c000)
   => /lib64/ (0x00007fad2d714000)
   => /lib64/ (0x00007fad2d424000)
   => /lib64/ (0x00007fad2d21c000)
   => /lib64/ (0x00007fad2cfec000)
   => /lib64/ (0x00007fad2cdcc000)
   => /lib64/ (0x00007fad2cbbc000)
   => /lib64/ (0x00007fad2c9b4000)
   => /lib64/ (0x00007fad2c78c000)
Sign In or Register to comment.

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.