Re: working with users

On Tue, Oct 14, 2003 at 21:17:16 -0400,
  Sam Carleton <postgres@linux-info.net> wrote:
>
> But how do I see what users exist for the database?  Because I was
One way is to use the \du command in psql.

> 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

Yes.

> when I run psql as postgres?  If I am postgres, what is the password
> to the database and how do I rest it?

By default the access mode is trust, so there is no password needed.

> 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?

Yes. They are described in the documentation under the headings
internals -> system catalogs.

You also might want to use \? to see the \ commands available in psql,
since there are a number of lookups using \ commands that might be
of interest to you.