Re: Where can I get Users and Roles information in PostgreSQL

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