Re: silence and failure of SQL commands

From: Leif Biberg Kristensen <leif(at)solumslekt(dot)org>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: silence and failure of SQL commands
Date: 2011-04-28 20:42:44
Message-ID: 201104282242.44925.leif@solumslekt.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Thursday 28 April 2011 22:22:24 Robert Poor wrote:

> postgres=# SELECT * FROM users
> +#

Just a piece of advice, since this is a novice list: postgres is a privileged
user (per default *the* privileged user), and you should never log in and
execute queries as such unless there is a very specific reason to do so. You
should create a user with ordinary privileges and normally use that account.
Otherwise, you run a great risk of shooting yourself in the foot, as a lot of
people have realized a little too late.

The prompt for a regular user will appear as => while the =# shows that you're
logged in as a super-user.

regards, Leif

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Robert Poor 2011-04-28 20:54:36 Re: silence and failure of SQL commands
Previous Message Lew 2011-04-28 20:33:19 Re: failure and silence of SQL commands