Have a look at the system views pg_user and pg_group - Stuart > -----Original Message----- > From: Andy Ruhl [mailto:[EMAIL PROTECTED]] > 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 > > -- > [EMAIL PROTECTED] > SDF Public Access UNIX System - http://sdf.lonestar.org > >
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
