Обсуждение: how to invoke edtor?
HI, how can I invoke editor like vim from postgres? This helps me in editing large and complex queries. Thanks
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
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
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.
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