Re: silence and failure of SQL commands

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