Re: Nvim as external editor in psql as Postgres root user - .vimrc (environment?) issue

Ok, here is a clumsy solution.

I have this entry in my /home/victoria/.psqlrc file,

\setenv EDITOR "/usr/bin/nvim"

As you see below, I symlink to that file, from postgres.

[victoria(at)victoria ~]$ sudo -u postgres -i

[postgres(at)victoria ~]$ pwd

/var/lib/postgres

[postgres(at)victoria ~]$ ls -la

total 108
drwxrwxr-x 6 postgres victoria 4096 Mar 16 12:48 .
drwxr-xr-x 33 root root 4096 Mar 16 00:00 ..
-rw------- 1 postgres postgres 385 Mar 16 12:49 .bash_history
-rwxr-xr-x 1 root root 806 Mar 16 12:41 .bashrc
drwx------ 2 postgres postgres 4096 Mar 16 12:23 .cache
drwxrwxr-x 2 postgres victoria 4096 Feb 23 13:26 data
drwx------ 3 postgres postgres 4096 Mar 16 12:12 .local
lrwxrwxrwx 1 postgres victoria 62 Feb 23 15:10 .psql_history-postgres -> /mnt/Vancouver/Programming/RDB/postgres/postgres/.psql_history
lrwxrwxrwx 1 postgres victoria 22 Feb 23 14:59 .psqlrc -> /home/victoria/.psqlrc
drwxr-xr-x 2 postgres postgres 4096 Mar 16 12:38 .vim
-rw------- 1 postgres postgres 895 Mar 16 12:48 .viminfo
-rw-r--r-- 1 postgres postgres 68234 Mar 16 12:47 .vimrc

## NOTE: .bashrc and .vimrc are edited COPIES (not symlinks) of /home/victoria/{.bashrc | .vimrc}

[postgres(at)victoria ~]$ cat /var/lib/postgres/.bashrc

export PSQL_EDITOR="/usr/bin/nvim -u /var/lib/postgres/.vimrc"

## "/var/lib/postgres/.vimrc" is the same as "/home/victoria/.vimrc" EXCEPT
## that I commented out line 77, "execute pathogen#infect(), as that was
## throwing an error when starting nvim (Neovim) as the psql \e external editor.

## Important (slight annoyance: need to load that "postgres" .bashrc file:

[postgres(at)victoria ~]$ exec bash

[postgres(at)victoria ~]$ psql

psql (10.2)
Type "help" for help.

[postgres]# \e ## can edit in Neovim, with ~/.vimrc settings, preferences, customizations ...

[postgres]# \q

[postgres(at)victoria ~]$ exit

exit

[victoria(at)victoria ~]$

I wasn't able to automatically run the "exec bash" command after starting postgres, hence the need to manually run it in the postgres shell, prior to launching psql.

==============================================================================