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