psql client auto completion in edit mode using vi

Question

In psql client, you can enter input edit mode with \e, witch calls an editor, witch in my case is vim (similar to ctrl+x-ctrl+e in bash). Is there a way to achieve same syntax auto completion capabilities in this edit mode as simply typing in psql gives (autocompletion support for syntax and object names like tables, schemes, sequences, types and etc... )?

Answer 1

Have you searched vim.org?

• dbext.vim provides (among other features) completion:

dbext ties into Vim dictionary feature. You can complete table names, procedure names and view names using the i_CTRL-X_CTRL-K feature

• psql.vim provides syntax highlighting. The script is quite old, though; don't know whether all keywords are supported