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 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
