Have a look at the system views pg_user and pg_group
- Stuart
> -----Original Message-----
> From: Andy Ruhl [mailto:acruhl@sdf.lonestar.org]
> Sent: 04 February 2002 13:33
> To: sreedhar
> Cc: PostgreSQL
> Subject: Re: Where can I get Users and Roles information in PostgreSQL
>
>
> On Mon, 4 Feb 2002, sreedhar wrote:
>
> > Hi all,
> >
> > I am new bee to PostgreSQL. Where can I get Users and Roles
> information in
> > PostgreSQL.
> >
> > eg : In SQL-SERVER we can get users information using
> 'sysusers' table.
> >
> > advance thanks for helping,
>
> I'm new too, so this may not be the best answer, but it's
> useful anyway.
>
> If you are a superuser (ie: you can create other users), try this:
>
> select * from pg_shadow;
>
> Warning: Passwords will be shown in plain text. If you don't
> want anyone
> to see, make sure nobody is standing behind you!
>
> Andy
>
> --
> acruhl@sdf.lonestar.org
> SDF Public Access UNIX System - http://sdf.lonestar.org
>
>