Vertica Quick Tip: Using a Preferred Editor in VSQL

Posted April 17, 2018 by Soniya Shah, Information Developer

Shot of two businesswomen using a digital tablet together during a collaboration at work
This blog post was authored by Jim Knicely. The vsql \e and \edit meta-commands let you edit the query buffer (or specified file) with an external editor. The default editor on Linux is vi and notepad.exe on Windows systems. Because vsql searches the environment variables VSQL_EDITOR, EDITOR, and VISUAL (in that order) for an editor to use, you can set one to your preferred editor! Example: [dbadmin@s18384357 ~]$ export EDITOR=vim For folks that use vsql and the editor VIM, you can enable syntax highlight by adding the following lines to ~/.vimrc : if $_ == "/opt/vertica/bin/vsql" set syntax=sql endif Have Fun!