Skip site navigation (1) Skip section navigation (2)

Re: how to invoke edtor?

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Jagadeesh <mnjagadeesh(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: how to invoke edtor?
Date: 2008-10-10 09:07:40
Message-ID: 48EF1B5C.4010103@lelarge.info (view raw or flat)
Thread:
Lists: pgsql-admin
Jagadeesh a écrit :
> On Oct 10, 9:42 am, Jagadeesh <mnjagade(dot)(dot)(dot)(at)gmail(dot)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

In response to

pgsql-admin by date

Next:From: Julius TuskenisDate: 2008-10-10 09:15:29
Subject: Re: can I update multiple table at a time?
Previous:From: JagadeeshDate: 2008-10-10 07:57:25
Subject: Re: logging SQL statements

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group