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

On 03/16/2018 10:47 AM, Victoria wrote:
> Hello; I am using PostgreSQL v.10.2 as a root user (sudo -u postgres -i) on my local Arch Linux installation.
>
> I want to use Neovim (nvim v.0.2.2) as my external editor (\e) in psql; the current default is the Arch Linux default system editor, vi.
>
> If I add this to my ~/.psqlrc (/home/victoria/.psqlrc)
>
> \setenv EDITOR "/usr/bin/nano"
>
> then I can use nano, no problem.
>
> However, if I replace that with
>
> \setenv EDITOR "/usr/bin/nvim"
>
> and chown this postgres directory (to get around a .local/ permissions error that arises)
>
> sudo chown -R postgres:victoria /var/lib/postgres
>
> when I type \e in psql I can edit in nvim.
>
> The issue I have is that as I am in a postgres environment, my user (victoria) ~/.vimrc file (I link my nvim.init file to it) is not being loaded, so I don't have access to my Vim/NeoVim settings.

I guess the question is why sudo -u postgres -i? You can access the
server via psql from your home directory. If you want to work as
postgres user the simplest solution would be to add the .vimrc file to
the postgres user directory.

>
> I tried the nvim -u "<path-to-vimrc>" type statements in my ~/.psqlrc, but that throws an error about not a valid path (again, likely due to the Pg root environment?).
>
> Suggestions? Thank you.
>
> ==============================================================================
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com