Re: existence of user
От | Annie Bai |
---|---|
Тема | Re: existence of user |
Дата | |
Msg-id | F525XN5HpyOMIIHAgH4000084c6@hotmail.com обсуждение исходный текст |
Ответ на | existence of user ("Annie Bai" <annie_job@hotmail.com>) |
Ответы |
Re: existence of user
(Stephen Ingram <ingram@samsix.com>)
|
Список | 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
В списке pgsql-novice по дате отправления: