Using vsql Almost Anywhere

[Deleted User][Deleted User] 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.


[dbadmin@s18384357 ~]$ vsql
-bash: vsql: command not found

[dbadmin@s18384357 ~]$ scp /usr/bin

[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


Have Fun!


  • Jim_KnicelyJim_Knicely - Select Field - Administrator

    Note that the vsql CLI does have some several dependencies:

    [dbadmin@s18384357 ~]$ 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.