Vim SQL omnicomplete

Question

I'm trying to use the dynamic SQL auto completion (omni menu) feature in vim, but it's not working.

I'm using the Yakuake terminal on Linux Mint, and the DBext vim plugin is working.

I can do C-xC-o, but it only shows tables and I need columns too. I also can't drill with left and right.

If I’m in insert mode and I press C-c then it acts like I pressed Esc and goes back to normal mode.

When I type :SQLSetType pgsql it says "not an editor command".

Answer 1

i added

filetype plugin on

in my .vimrc file and the the hotkey is crtl+shift+c (like if you want to copy from terminal) after you press that combination you press t to show all the tables and then left to drill down to the columns of the highlighted table,

the rest is in

:h sql.txt

Answer 2

OK, so the ft_sql documentation seems to say that the shortcut to get to columns isn't C-c, but in fact C-C c which could either mean Ctrl-Shift-C and then hit c or it could mean Ctrl-LCtrl-c.

Unfortunately, it's more than a little strange, so keep trying combinations and see if you can find what works!

Answer 3

For whoever lands here: I've created a sql plugin for VIM, which also has intellisense: https://github.com/cosminadrianpopescu/vim-sql-workbench. It is based on SQL Workbench.