pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
how to invoke edtor?
5+ messages / 3 participants
[nested] [flat]

* how to invoke edtor?
@ 2008-10-10 04:42 Jagadeesh <mnjagadeesh@gmail.com>
  2008-10-10 07:46 ` Re: how to invoke edtor? Jagadeesh <mnjagadeesh@gmail.com>
  2008-10-10 14:40 ` Re: how to invoke edtor? Alvaro Herrera <alvherre@commandprompt.com>
  0 siblings, 2 replies; 5+ messages in thread

From: Jagadeesh @ 2008-10-10 04:42 UTC (permalink / raw)
  To: pgsql-admin

HI,

how can I invoke editor like vim from postgres? This helps me in
editing large and complex queries.
Thanks



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: how to invoke edtor?
  2008-10-10 04:42 how to invoke edtor? Jagadeesh <mnjagadeesh@gmail.com>
@ 2008-10-10 07:46 ` Jagadeesh <mnjagadeesh@gmail.com>
  2008-10-10 09:07   ` Re: how to invoke edtor? Guillaume Lelarge <guillaume@lelarge.info>
  1 sibling, 1 reply; 5+ messages in thread

From: Jagadeesh @ 2008-10-10 07:46 UTC (permalink / raw)
  To: pgsql-admin

On Oct 10, 9:42 am, Jagadeesh <mnjagade...@gmail.com> wrote:
> HI,
>
> 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.

Thanks



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: how to invoke edtor?
  2008-10-10 04:42 how to invoke edtor? Jagadeesh <mnjagadeesh@gmail.com>
  2008-10-10 07:46 ` Re: how to invoke edtor? Jagadeesh <mnjagadeesh@gmail.com>
@ 2008-10-10 09:07   ` Guillaume Lelarge <guillaume@lelarge.info>
  0 siblings, 0 replies; 5+ messages in thread

From: Guillaume Lelarge @ 2008-10-10 09:07 UTC (permalink / raw)
  To: Jagadeesh <mnjagadeesh@gmail.com>; +Cc: 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



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: how to invoke edtor?
  2008-10-10 04:42 how to invoke edtor? Jagadeesh <mnjagadeesh@gmail.com>
@ 2008-10-10 14:40 ` Alvaro Herrera <alvherre@commandprompt.com>
  2008-11-17 11:02   ` Re: how to invoke edtor? Jagadeesh <mnjagadeesh@gmail.com>
  1 sibling, 1 reply; 5+ messages in thread

From: Alvaro Herrera @ 2008-10-10 14:40 UTC (permalink / raw)
  To: Jagadeesh <mnjagadeesh@gmail.com>; +Cc: pgsql-admin

Jagadeesh escribió:
> HI,
> 
> how can I invoke editor like vim from postgres? This helps me in
> editing large and complex queries.

Use \e, and make sure EDITOR is set to the editor of your preference.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: how to invoke edtor?
  2008-10-10 04:42 how to invoke edtor? Jagadeesh <mnjagadeesh@gmail.com>
  2008-10-10 14:40 ` Re: how to invoke edtor? Alvaro Herrera <alvherre@commandprompt.com>
@ 2008-11-17 11:02   ` Jagadeesh <mnjagadeesh@gmail.com>
  0 siblings, 0 replies; 5+ messages in thread

From: Jagadeesh @ 2008-11-17 11:02 UTC (permalink / raw)
  To: pgsql-admin

On Oct 10, 7:40 pm, alvhe...@commandprompt.com (Alvaro Herrera) wrote:
> Jagadeesh escribió:
>
> > HI,
>
> > how can I invoke editor like vim from postgres? This helps me in
> > editing large and complex queries.
>
> Use \e, and make sure EDITOR is set to the editor of your preference.
>
> --
> Alvaro Herrera                                http://www.CommandPrompt.com/
> The PostgreSQL Company - Command Prompt, Inc.
>
> --
> Sent via pgsql-admin mailing list (pgsql-ad...@postgresql.org)
> To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-admin

This helped me a lot. Thanks for all you help.

Thanks
Jagadeesh



^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2008-11-17 11:02 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-10-10 04:42 how to invoke edtor? Jagadeesh <mnjagadeesh@gmail.com>
2008-10-10 07:46 ` Jagadeesh <mnjagadeesh@gmail.com>
2008-10-10 09:07   ` Guillaume Lelarge <guillaume@lelarge.info>
2008-10-10 14:40 ` Alvaro Herrera <alvherre@commandprompt.com>
2008-11-17 11:02   ` Jagadeesh <mnjagadeesh@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox