>>>>> "Tom" == Tom Lane <[EMAIL PROTECTED]> writes:
Tom> Raj Mathur <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] http://kandalaya.org/ It is the mind that moves ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org