Skip site navigation (1) Skip section navigation (2)

Re: silence and failure of SQL commands

From: Robert Poor <rdpoor(at)gmail(dot)com>
To: John Payne <jcpayne(at)uw(dot)edu>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: silence and failure of SQL commands
Date: 2011-04-28 20:22:24
Message-ID: BANLkTimrrDwdLv+6WqP02g_ihJ=cOhRnyg@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
John:

On Thu, Apr 28, 2011 at 13:08, John Payne <jcpayne(at)uw(dot)edu> wrote:
> A statistics program I use (R) has a simple and elegant
> solution: it drops the cursor one line and puts in a “+” sign.

Just for jollies, try typing this in:

\set PROMPT2 '+%# '

... and then try a command, intentionally omitting the semicolon:

postgres=# SELECT * FROM users
+#

... and see if you like the results.  If there's enough acclaim for
it, perhaps Tom will consider making it the default.

In response to

Responses

pgsql-novice by date

Next:From: Leif Biberg KristensenDate: 2011-04-28 20:23:45
Subject: Re: failure and silence of SQL commands
Previous:From: John PayneDate: 2011-04-28 20:08:02
Subject: silence and failure of SQL commands

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group