Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M42006=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1VswCI-0002wb-Nl
 for pgsql-admin@arkaria.postgresql.org; Tue, 17 Dec 2013 15:04:34 +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+M42006=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1VswCH-0007eI-Kn
 for pgsql-admin@arkaria.postgresql.org; Tue, 17 Dec 2013 15:04:33 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <polobo@yahoo.com>) id 1VswCG-0007eC-Ub
 for pgsql-admin@postgresql.org; Tue, 17 Dec 2013 15:04:33 +0000
Received: from sam.nabble.com ([216.139.236.26])
 by magus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <polobo@yahoo.com>) id 1VswC9-00081p-Rz
 for pgsql-admin@postgresql.org; Tue, 17 Dec 2013 15:04:32 +0000
Received: from [192.168.236.26] (helo=sam.nabble.com)
 by sam.nabble.com with esmtp (Exim 4.72)
 (envelope-from <polobo@yahoo.com>) id 1VswC6-0000LO-Bn
 for pgsql-admin@postgresql.org; Tue, 17 Dec 2013 07:04:22 -0800
Date: Tue, 17 Dec 2013 07:04:22 -0800 (PST)
From: David Johnston <polobo@yahoo.com>
To: pgsql-admin@postgresql.org
Message-ID: <1387292662322-5783726.post@n5.nabble.com>
In-Reply-To: <52B063DF.2020508@pinpointresearch.com>
References: 
 <CAK=muZtrjsYnXMsqq84bMf5gLY1ytcCjw4ORu48pD0m-bvpMrA@mail.gmail.com>
 <52B063DF.2020508@pinpointresearch.com>
Subject: Re: Notice about psql !
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: 1.8 (+)
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

Steve Crawford wrote
> 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.

Or

BEGIN; <Enter>

\e <Enter>

COMMIT | ROLLBACK ; <Enter>

David J.







--
View this message in context: http://postgresql.1045698.n5.nabble.com/Notice-about-psql-tp5783659p5783726.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.


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