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

2018-03-16 Thread Victoria
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

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

2018-03-16 Thread Victoria
Adrian: "... simplest solution would be to add the .vimrc file to the postgres user directory ..." Good suggestion; I tried that previously, but will try it again. Thanks! :-)

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

2018-03-16 Thread Victoria
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@victoria ~]$ sudo -u postgres -i [postgres@victoria ~]$ pwd /var/lib/postgres [postgres@victo

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

2018-03-16 Thread Victoria Stuart (VictoriasJourney.com)
this: [victoria@victoria ~]$ pwd /home/victoria [victoria@victoria ~]$ createuser -s -U postgres --interactive Enter name of role to add: victoria createuser: creation of new role failed: ERROR: role "victoria" already exists [victoria@victoria ~]$ createdb