Re: existence of user - Mailing list pgsql-novice

Hi Steve,

How can I access the system databases? when I use '\l', i can only get those
databases created by specific users. Is there a particular directory holding
all the system databases?

Thanks a lot


>From: Stephen Ingram <ingram@samsix.com>
>Reply-To: ingram@samsix.com
>To: "Annie Bai" <annie_job@hotmail.com>, pgsql-novice@postgresql.org
>Subject: Re: [NOVICE] existence of user
>Date: Sat, 2 Feb 2002 19:35:27 -0500
>
>On Saturday 02 February 2002 07:18 pm, Annie Bai wrote:
> > Hi,
> >
> > After I used 'create user', Is there a database to keep all the
>information
> > about users? How can i check the existence of users?
> >
> > Thanks,
> > Yan
> >
>
>Hi,
>
>Sure. Check out the pg_user table.
>
>Postgres 'system' tables all seem to start with 'pg_'
>
>si@guinness > psql -c "select * from pg_user"
>  usename  | usesysid | usecreatedb | usetrace | usesuper | usecatupd |
>passwd  | valuntil
>----------+----------+-------------+----------+----------+-----------+----------+----------
>  postgres |       26 | t           | t        | t        | t         |
>******** |
>  si       |       27 | t           | f        | t        | t         |
>******** |
>  nrg      |       30 | t           | f        | t        | t         |
>******** |
>  testuser |       28 | t           | f        | t        | t         |
>******** |
>  sm       |       31 | t           | f        | t        | t         |
>******** |
>  tc       |       32 | t           | f        | t        | t         |
>******** |
>  nrgadmin |       33 | t           | f        | t        | t         |
>******** |
>  dude     |       29 | t           | f        | t        | t         |
>******** |
>  ken      |       34 | t           | f        | t        | t         |
>******** |
>(9 rows)
>
>steve
>
>
> > _________________________________________________________________
> > Get your FREE download of MSN Explorer at
>http://explorer.msn.com/intl.asp.
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster


_________________________________________________________________
Join the world�s largest e-mail service with MSN Hotmail.
http://www.hotmail.com