Re: silence and failure of SQL commands

From: Robert Poor <rdpoor(at)gmail(dot)com>
To: Leif Biberg Kristensen <leif(at)solumslekt(dot)org>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: silence and failure of SQL commands
Date: 2011-04-28 20:54:36
Message-ID: BANLkTi=jw8hPKL=2XAzJZBkM9J_h5JtnWA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Lief:

On Thu, Apr 28, 2011 at 13:42, Leif Biberg Kristensen
<leif(at)solumslekt(dot)org> wrote:
> On Thursday 28 April 2011 22:22:24 Robert Poor wrote:
>> postgres=# SELECT * FROM users
>> +#
> The prompt for a regular user will appear as => while the =# shows that you're
> logged in as a super-user.

You are totally correct -- thou shalt not assume super-user privs
without cause. I was using the "#" notation to be consistant with
Tom's previous post.

But this doesn't change my suggestion about changing

\set PROMPT2 '+%# '

The "%#" token at the end expands to "#" for the super user and ">"
for us mere mortals. So I could have typed my example as:

postgres=> SELECT * FROM users
+>

... which I think would satisfy the needs of new-ish users such as
myself and John.

- Rob

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Leif Biberg Kristensen 2011-04-28 21:06:30 Re: silence and failure of SQL commands
Previous Message Leif Biberg Kristensen 2011-04-28 20:42:44 Re: silence and failure of SQL commands