Re: Users and groups

>>>>> "Tom" == Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

Tom> Raj Mathur <raju(at)linux-delhi(dot)org> writes:
>> ... However, the complementary process, determining all the
>> users in group administrators, isn't so clean.

Tom> Doesn't select grolist from pg_group where groname =
Tom> 'administrators' do it for you? I suppose you might want the
Tom> thing to map sysids back to usernames ...

Ah, maybe I should have been more explicit: need a list of usename's
of users who are admins. Any simple command (set) to do that?

Regards,

-- Raju
--
Raj Mathur raju(at)kandalaya(dot)org http://kandalaya.org/
It is the mind that moves