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

From: Victoria <victorias(dot)linux(at)gmail(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Cc: Victorias(dot)Linux(at)gmail(dot)com
Subject: Nvim as external editor in psql as Postgres root user - .vimrc (environment?) issue
Date: 2018-03-16 17:47:46
Message-ID: 20180316104746.1e23e682@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 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.

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2018-03-16 17:58:10 Re: Nvim as external editor in psql as Postgres root user - .vimrc (environment?) issue
Previous Message Charlin Barak 2018-03-16 17:12:08 ora2pg and invalid command \N