working with users

From: Sam Carleton <ehc(at)linux-info(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: working with users
Date: 2003-10-15 01:10:52
Message-ID: 20031015011052.GA8143@miltonstreet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Ok, I am a newbie, but I simply cannot find anything in the
documentation so I hope you all are kind to me...

I have installed Postgres 7.3.4 (will reinstall once I get OpenSLL
compiled into it). I created the postgres user, and the first
database. As the postgress user, I am able to run psql and access
the database that I created. I have been able to run the create
user command.

But how do I see what users exist for the database? Because I was
the user postgres when I created the database, does that mean there
was a postgres user added during creation? If not, what user am I
when I run psql as postgres? If I am postgres, what is the password
to the database and how do I rest it?

Now I am not a DBA, but I have been around enough databases to know
that most of them have their own system tables. Does postgres have
system tables? If so, where do I find a list of them and their
usage?

Sam

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Sam Carleton 2003-10-15 01:17:16 working with users
Previous Message j sk 2003-10-15 00:58:21 DELETE error - Memory exhausted in AllocSetAlloc