Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M42005=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1VsvvN-0002BF-Dn
 for pgsql-admin@arkaria.postgresql.org; Tue, 17 Dec 2013 14:47:05 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M42005=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1VsvvM-0004LC-Th
 for pgsql-admin@arkaria.postgresql.org; Tue, 17 Dec 2013 14:47:04 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <scrawford@pinpointresearch.com>) id 1VsvvL-0004L5-R3
 for pgsql-admin@postgresql.org; Tue, 17 Dec 2013 14:47:03 +0000
Received: from cerberus.pinpointresearch.com ([66.7.238.130]
 helo=polaris.pinpointresearch.com)
 by magus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <scrawford@pinpointresearch.com>) id 1VsvvF-0007iL-GH
 for pgsql-admin@postgresql.org; Tue, 17 Dec 2013 14:47:03 +0000
Received: from [192.168.1.179] (betelgeuse.pinpointresearch.com
 [192.168.1.179])
 by polaris.pinpointresearch.com (Postfix) with ESMTP id 1E880E00EC83;
 Tue, 17 Dec 2013 06:46:55 -0800 (PST)
Message-ID: <52B063DF.2020508@pinpointresearch.com>
Date: Tue, 17 Dec 2013 06:46:55 -0800
From: Steve Crawford <scrawford@pinpointresearch.com>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:24.0) Gecko/20100101 Thunderbird/24.1.1
MIME-Version: 1.0
To: "Doom.zhou" <zzepaigh@gmail.com>, pgsql-admin@postgresql.org
Subject: Re: Notice about psql !
References: 
 <CAK=muZtrjsYnXMsqq84bMf5gLY1ytcCjw4ORu48pD0m-bvpMrA@mail.gmail.com>
In-Reply-To: 
 <CAK=muZtrjsYnXMsqq84bMf5gLY1ytcCjw4ORu48pD0m-bvpMrA@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -2.4 (--)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

On 12/16/2013 09:29 PM, Doom.zhou wrote:
> HI guys
>     when edit some sql in psql's \e feature then quit edit
> it is performed !!!!
>
>
> it's dangerous isn't it ?
>
It is *extremely* dangerous. But neither more nor less dangerous than 
any interface that allows you to submit SQL directly to the server.

The \e command merely offers an alternative to the command-line editing 
to craft your SQL statements and is very convenient when you are editing 
a long statement. When done, you exit and the command is submitted just 
as it is submitted when you press <Enter> at the command-line.

If you change your mind while in the editor, just clear the text in the 
editor and exit. Nothing will be run.

Cheers,
Steve



-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin