Keybindings in VSQL - Need help!

[flipperbw]

Hi there - getting a bit frustrated with setting vsql keybindings. I'm trying to set control-left and control-right to skip words left and right, and also trying to set forward delete.

I came across this doc:
http://my.vertica.com/docs/4.1/HTML/Master/2735.htm
which explains that vsql uses the tecla library, specifically .teclarc.

So naturally, I read through the tecla docs:
ro.altech.edu/~mcs/tecla/tecla.html

And tried all of the following to no avail [note: hitting control v for the escape sequence]:
bind ^[[1;5D backward-word
bind '^[[1;5D' backward-word
bind '^[-left' backward-word
bind ^left backward-word
...etc...

When none of that worked, I tried using \bind in vsql. When that didn't work, I tried putting gibberish in the .teclarc doc, and absolutely nothing happened. It looks like it's not even being read. I have vsql version 4.1.9.

Should I be somehow doing this in .vsqlrc instead? The docs don't provide much clarity on it.

Thanks!

[id10t]

Hi, flipperbw!

Try next (as root in /opt/vertica/config/vsqlrc or as user in ~/.vsqlrc):

Code: Select all

\edit-mode emacs
...
\bind [1;5C forward-word 
\bind [1;5D backward-word

[flipperbw]

Ah, so it works when i put it in .vsqlrc! I was confused because when I try the same thing on the command line once in vsql, the \bind command doesn't seem to do anything. Nonetheless, I'll use .vsqlrc instead of .teclarc. Thanks!

[Julie]

OMG, I was having a similar issue. I think you may have solved my problem too! Great!