The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
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

[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.