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.