Received: from mail01.phoenixdsl.com (mail.phoenixdsl.com [216.178.151.24]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f0O2u0028082 for ; Tue, 23 Jan 2001 21:56:00 -0500 (EST) (envelope-from mdavis@sevainc.com) Received: (qmail 42721 invoked by uid 89); 24 Jan 2001 02:55:54 -0000 Received: from unknown (HELO SALLY) (64.32.157.45) by 0 with SMTP; 24 Jan 2001 02:55:54 -0000 Received: by localhost with Microsoft MAPI; Tue, 23 Jan 2001 19:55:52 -0700 Message-ID: <01C08576.7D763D70.mdavis@sevainc.com> From: Michael Davis Reply-To: "mdavis@sevainc.com" To: "'chard'" , "pgsql-sql@postgresql.org" Subject: RE: retrieving user's groups Date: Tue, 23 Jan 2001 19:55:45 -0700 Organization: Seva Inc. X-Mailer: Microsoft Internet E-mail/MAPI - 8.0.0.4211 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Archive-Number: 200101/302 X-Sequence-Number: 971 Here's a start: select g.groname as group, g.grosysid as group_id, u.usename as user, u.usesysid as user_id from pg_group g, pg_user u where u.usesysid = g.grolist[1] or u.usesysid = g.grolist[2] or u.usesysid = g.grolist[3] or u.usesysid = g.grolist[4] or u.usesysid = g.grolist[5] or u.usesysid = g.grolist[6] or u.usesysid = g.grolist[7] or u.usesysid = g.grolist[8] or u.usesysid = g.grolist[9] or u.usesysid = g.grolist[10] order by groname, usename; -----Original Message----- From: chard [SMTP:chard@hindang.msuiit.edu.ph] Sent: Tuesday, January 23, 2001 7:39 PM To: pgsql-sql@postgresql.org Subject: retrieving user's groups hello, how will i retrieve group names of a certain user? using sql. richard