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@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