On Tue, Oct 14, 2003 at 21:17:16 -0400, Sam Carleton <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster