The situation is the following. This is an Ubuntu box:
Linux ns3mx3 2.6.32-41-server #89-Ubuntu SMP Fri Apr 27 22:33:31 UTC 2012 x86_64 GNU/Linux
Which means that when I first issue
psql, I'm asked to choose an editor. Then there is the
.selected_editor file, which contains
# Generated by /usr/bin/select-editor SELECTED_EDITOR="/usr/bin/mcedit-debian"
So far this is OK (it's my problem that I consider this completely useless, but never mind).
Then I set up a
\set PSQL_EDITOR /usr/bin/vim \set EDITOR /usr/bin/vim \set VISUAL /usr/bin/vim
As you can see, I wanted to be sure not to miss a candidate variable for editor setting. The file is used as expected:
test=# \echo :EDITOR /usr/bin/vim
But when I issue the
\e command, none of these is used - I fall back to
SELECTED_EDITOR. The situation remains just the same if I append an
\unset SELECTED_EDITOR to the
Now how can I make
.psqlrc setting win over the default editor?
(PostgreSQL version id 9.1.4)