Re: existence of user

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