On Thu, 26 Feb 2004 16:47:10 -0500, Alexander Cohen <[EMAIL PROTECTED]> wrote: > Im trying to get a list of all groups that a certain user is a member > of. Can anyone help me with the sql to get that?
select groname >from pg_group where (select usesyside from pg_shadow where usename = 'postgres') = any(grolist); klint. +---------------------------------------+-----------------+ : Klint Gore : "Non rhyming : : EMail : [EMAIL PROTECTED] : slang - the : : Snail : A.B.R.I. : possibilities : : Mail University of New England : are useless" : : Armidale NSW 2351 Australia : L.J.J. : : Fax : +61 2 6772 5376 : : +---------------------------------------+-----------------+ ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org