Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 937FC64FD6B for ; Mon, 17 Nov 2008 07:10:05 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 10451-04 for ; Mon, 17 Nov 2008 07:10:02 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by mail.postgresql.org (Postfix) with ESMTP id 4037564FD48 for ; Mon, 17 Nov 2008 07:10:02 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.14.1/8.14.1) with ESMTP id mAHB9wOZ055810 for ; Mon, 17 Nov 2008 07:09:58 -0400 (AST) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.14.1/8.14.1/Submit) id mAHB2HlM047316 for pgsql-admin@postgresql.org; Mon, 17 Nov 2008 07:02:17 -0400 (AST) (envelope-from news) From: Jagadeesh X-Newsgroups: pgsql.admin Subject: Re: how to invoke edtor? Date: Mon, 17 Nov 2008 03:02:20 -0800 (PST) Organization: http://groups.google.com Lines: 24 Message-ID: References: <20081010144003.GA4194@alvh.no-ip.org> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Complaints-To: groups-abuse@google.com Complaints-To: groups-abuse@google.com Injection-Info: v5g2000prm.googlegroups.com; posting-host=116.197.178.83; posting-account=P28yfwoAAACRVwAnrDsu8yF8ALsATLSu User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.18) Gecko/20081112 Fedora/2.0.0.18-1.fc8 Firefox/2.0.0.18 pango-text, gzip(gfe), gzip(gfe) To: pgsql-admin@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200811/84 X-Sequence-Number: 30738 On Oct 10, 7:40 pm, alvhe...@commandprompt.com (Alvaro Herrera) wrote: > Jagadeesh escribi=F3: > > > 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.co= m/ > 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/p= gsql-admin This helped me a lot. Thanks for all you help. Thanks Jagadeesh