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

From Steve Crawford
Subject Re: Notice about psql !
Date
Msg-id 52B063DF.2020508@pinpointresearch.com
Whole thread Raw
In response to Notice about psql !  ("Doom.zhou" <zzepaigh@gmail.com>)
Responses Re: Notice about psql !  (David Johnston <polobo@yahoo.com>)
List pgsql-admin
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



pgsql-admin by date:

Previous
From: Marcin Krawczyk
Date:
Subject: Re: [SQL] Scheduled Events
Next
From: David Johnston
Date:
Subject: Re: Notice about psql !