Re: Notice about psql ! - Mailing list pgsql-admin

From Bruce Momjian
Subject Re: Notice about psql !
Date
Msg-id 20131218025842.GB6509@momjian.us
Whole thread Raw
In response to Re: Notice about psql !  ("Doom.zhou" <zzepaigh@gmail.com>)
List pgsql-admin
On Wed, Dec 18, 2013 at 10:35:33AM +0800, Doom.zhou wrote:
> Really thanks 
>
>
> On Tue, Dec 17, 2013 at 11:04 PM, David Johnston <polobo@yahoo.com> wrote:
>
>     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>

Actually, just remove the semicolon from the query and it will not run
when you exit \e.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +


pgsql-admin by date:

Previous
From: "Doom.zhou"
Date:
Subject: Re: Notice about psql !
Next
From: "Doom.zhou"
Date:
Subject: Re: script to drop and create all indexes in a database with parameter concurrently