From: | "Annie Bai" <annie_job(at)hotmail(dot)com> |
---|---|
To: | ingram(at)samsix(dot)com, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: existence of user |
Date: | 2002-02-03 01:30:48 |
Message-ID: | F525XN5HpyOMIIHAgH4000084c6@hotmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)samsix(dot)com>
>Reply-To: ingram(at)samsix(dot)com
>To: "Annie Bai" <annie_job(at)hotmail(dot)com>, pgsql-novice(at)postgresql(dot)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(at)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 worlds largest e-mail service with MSN Hotmail.
http://www.hotmail.com
From | Date | Subject | |
---|---|---|---|
Next Message | Annie Bai | 2002-02-03 01:37:19 | Re: existence of user |
Previous Message | Stephen Ingram | 2002-02-03 00:35:27 | Re: existence of user |