Re: how to invoke edtor? - Mailing list pgsql-admin

Jagadeesh a écrit :
> On Oct 10, 9:42 am, Jagadeesh <mnjagade...@gmail.com> wrote:
>>[...]
>> how can I invoke editor like vim from postgres? This helps me in
>> editing large and complex queries.
>> Thanks
>
> I just got to know emacs can be used for it. Is there any other
> method?
> I am using FreeBSD.
>

Change the EDITOR environment variable.

export EDITOR=vim

and psql will use vim as the query editor with \e metacommand.


--
Guillaume.
 http://www.postgresqlfr.org
 http://dalibo.com