Re: silence and failure of SQL commands - Mailing list pgsql-novice

From Leif Biberg Kristensen
Subject Re: silence and failure of SQL commands
Date
Msg-id 201104282242.44925.leif@solumslekt.org
Whole thread Raw
In response to Re: silence and failure of SQL commands  (Robert Poor <rdpoor@gmail.com>)
Responses Re: silence and failure of SQL commands
List 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

pgsql-novice by date:

Previous
From: Lew
Date:
Subject: Re: failure and silence of SQL commands
Next
From: Robert Poor
Date:
Subject: Re: silence and failure of SQL commands