Prompt question

Hello all,

I have a question. I'm
currently running version 7.0.3 (compiled myself using debuild) on
debian-m68k potato. When I start psql, my prompt doesn't look like every
example I've seen. The examples are like this: "mydb=>" My prompt looks like
this: "test=#" (no quotes, of course) I don't know if this is significant or
not, obviously it is in Linux, but in Postgres I don't know.

Thank you for any thought you may offer on this subject.

Russell

____________________________________________________
_its_ (no apostrophe) means "the thing that it owns"
_it's_ (with apostrophe) means "it is"

On Sun, 11 Mar 2001, Russell Hires wrote:

I have a question. I'm
currently running version 7.0.3 (compiled myself using debuild) on
debian-m68k potato. When I start psql, my prompt doesn't look like every
example I've seen. The examples are like this: "mydb=>" My prompt looks like
this: "test=#" (no quotes, of course) I don't know if this is significant or
not, obviously it is in Linux, but in Postgres I don't know.

Usually you get that prompt when you are logged in as the postgres
superuser (usually postgres). Is this the case here?

-- Brett
http://www.chapelperilous.net/~bmccoy/
------------------------------------------------------------------------
If voting could change the system, it would be illegal. If not voting
could change the system, it would be illegal.

"Russell Hires" wrote:

Hello all,

I have a question. I'm
currently running version 7.0.3 (compiled myself using debuild) on
debian-m68k potato. When I start psql, my prompt doesn't look like every
example I've seen. The examples are like this: "mydb=>" My prompt looks like
this: "test=#" (no quotes, of course) I don't know if this is significant or
not, obviously it is in Linux, but in Postgres I don't know.

The prompt indicates whether you have administrator privileges in
PostgreSQL. Here's an illustration:

bray=# select usename, usesuper from pg_user;
usename | usesuper
----------+----------
postgres | t
dan | f
ruth | f
olly | t
hoho | f
(6 rows)

bray=# \c - dan
You are now connected as new user dan.
bray=> \c - olly
You are now connected as new user olly.
bray=#

--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"Who is like Thee among the gods, O Lord? Who is like
Thee, majestic in holiness, awesome in praises,
working wonders?"
Exodus 15:11

Usually you get that prompt when you are logged in as the postgres
superuser (usually postgres). Is this the case here?

Well, no, I'm just logged in as plain ol' me. When I created myself as a new
user I answered yes to both questions about whether I'm allowed to add other
users and add databases. Does that make me an administrator/superuser?

Russell

____________________________________________________
_its_ (no apostrophe) means "the thing that it owns"
_it's_ (with apostrophe) means "it is"

----------

"Russell Hires" wrote:

Usually you get that prompt when you are logged in as the postgres
superuser (usually postgres). Is this the case here?

Well, no, I'm just logged in as plain ol' me. When I created myself as a new
user I answered yes to both questions about whether I'm allowed to add other
users and add databases. Does that make me an administrator/superuser?

Yes

--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"Blessed are the poor in spirit, for theirs is the
kingdom of heaven...Blessed are they which do hunger
and thirst after righteousness, for they shall be
filled...Blessed are the pure in heart, for they shall
see God." Matthew 5:3,6,8