Installing the vsql client

The vsql client is installed as part of the Vertica server rpm.

The vsql client is installed as part of the Vertica server rpm. It is also available as a download for other Unix-based systems.

Linux and macOS

To install vsql manually on another system:

  1. Download vsql.

  2. Extract or install vsql:

    • If you downloaded the .tar, create the /opt/vertica/ directory if it does not already exist, copy the .tar to it, navigate to it, and extract the .tar:

      
      $ mkdir -p /opt/vertica/
      $ cp driver_name.tar.gz /opt/vertica/
      $ tar vzxf driver_name.tar.gz
      
    • If you downloaded the .rpm, install it with:

      $ rpm -Uvh driver_name.rpm
      
  3. Optionally add the vsql directory to your PATH. For example:

    $ export PATH=$PATH:\opt\vertica\bin
    
  4. Make the vsql client executable. For example, to allow all users to run vsql:

    $ chmod ugo+x /path/to/vsql
    
  5. Set your shell locale to a locale supported by vsql (which ones?). For example, in your .profile, add:

    export LANG=end_US.UTF-8
    

Windows installation

vsql on Windows is installed as part of the Windows Client Driver package. For installation details, see The Vertica client drivers and tools for windows.

See Using vsql for windows users for details on using vsql in a Windows console.