Using vsql Almost Anywhere

SarahLSarahL Administrator, Moderator, Employee, Registered User, VerticaExpert, CABuser, VerticaPartners
edited May 2018 in Vertica Tips

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, Moderator, Employee, Registered User, VerticaExpert

    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.