vsql is Vertica’s character-based, interactive, front-end utility that lets you type SQL statements and see the results.
If you’ve typed a particularly long query in vsql then realize that you’d have a typo way back at the beginning of your code (i.e. you wrote SEELECT), instead of holding down the back arrow key to navigate back to your syntax error, you can simply use the shortcut Ctrl + a to quickly return to the beginning of the line!
Here is a list of the vsql shortcuts I use most often:
• Move to the start of line: Ctrl + a
• Move to the end of line: Ctrl + e
• Move forward a word: Alt + f (a word contains alphabets and digits, no symbols)
• Move backward a word: Alt + b
• Clear the screen: Ctrl + l
Have Fun!
About the Author
Soniya Shah
Information Developer
Currently, a first year law student with a background in science and technology. Experienced technical writer, with specializations in software documentation, big data, blog development, and website development. I build user-centered content to communicate complex and technical information more easily.
I used to work for Vertica full time for about 3 years. I still work at Vertica part time while going to law school.
Update: Soniya is now doing her law internship, and no longer working at Vertica. Good luck, Soniya!
