From rjessil@yahoo.com Thu Jul 5 15:33:00 2007 Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 2433E9FA4C3 for ; Thu, 5 Jul 2007 12:33:00 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 01582-04 for ; Thu, 5 Jul 2007 12:32:55 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from web56415.mail.re3.yahoo.com (web56415.mail.re3.yahoo.com [216.252.111.94]) by postgresql.org (Postfix) with SMTP id 896599FA4C2 for ; Thu, 5 Jul 2007 12:32:55 -0300 (ADT) Received: (qmail 53356 invoked by uid 60001); 5 Jul 2007 15:32:54 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=WGZwPeHUU4nBfe8bwpdn6gDUPFVr6/23AIVlilMNzRXhidA98UHrmCFBrLfg5mZlSyudtwliX5zs9lYk6dsXK1MjsOzDSrhdjKR6qUHjCanfGeHCYgQ4JYDAHGeoc8yflXsLu/6wNSWTVpSvXCSVyN6zCl4Mzse/7BpiJ5XMsTA=; X-YMail-OSG: Z9y978QVM1maq9EHyiile7egI.MiCQ7rbuophPYquyGkCopvzEoUA9Bc02qrAXOMsg-- Received: from [198.119.134.32] by web56415.mail.re3.yahoo.com via HTTP; Thu, 05 Jul 2007 08:32:54 PDT Date: Thu, 5 Jul 2007 08:32:54 -0700 (PDT) From: Jessica Richard Subject: how to get a list of members of a postgres group? To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1924569079-1183649574=:53334" Content-Transfer-Encoding: 8bit Message-ID: <384522.53334.qm@web56415.mail.re3.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.265 tagged_above=0 required=5 tests=AWL=-0.847, BAYES_20=-0.74, DNS_FROM_RFC_ABUSE=0.2, DNS_FROM_RFC_POST=1.708, DNS_FROM_RFC_WHOIS=1.447, HTML_40_50=0.496, HTML_MESSAGE=0.001 X-Spam-Level: ** X-Archive-Number: 200707/40 X-Sequence-Number: 26021 --0-1924569079-1183649574=:53334 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Creatred a group, added members to the group, what command to use to check the current members in the group? thanks. --------------------------------- We won't tell. Get more on shows you hate to love (and love to hate): Yahoo! TV's Guilty Pleasures list. --0-1924569079-1183649574=:53334 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Creatred a group, added members to the group, what command to use to check the current members in the group?  thanks.


We won't tell. Get more on shows you hate to love
(and love to hate): Yahoo! TV's Guilty Pleasures list. --0-1924569079-1183649574=:53334-- From sibtay@gmail.com Thu Jul 5 18:14:54 2007 Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 523CC9FB950 for ; Thu, 5 Jul 2007 15:14:54 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 37971-04 for ; Thu, 5 Jul 2007 15:14:51 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.231]) by postgresql.org (Postfix) with ESMTP id EA0819FB51A for ; Thu, 5 Jul 2007 15:14:50 -0300 (ADT) Received: by nz-out-0506.google.com with SMTP id l8so1640184nzf for ; Thu, 05 Jul 2007 11:14:50 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=AE3MXhNPT0urvcCCAe4PCQjNIqiJkz0C/r1ejMS5AQpOa/ExxPLjAW/jHIjl2Gn2cgmOP5+YSN72F1ntQOS75+AClUVZc5kJba7aPKpR7NZPGMvYDFJ6FAHWimaT6BohcIBqsIIeLSJgvvLrkyxB365om70Wzk5+/1KP0wkFrkA= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=B+uQ6KHPN4SKSm625oP+C5Ecgju9T13tgklRYXY6vOH4+YAJtzqFfcoFeZiAB9P8FxqO+f/hKjeloA/pup4Adl1PggBD9lh86682u+QBHC+d3AuuNdUvyXj9kt9LohtGkLLi6MKl5StsrDX8w2piRzgdP8mSg4/+TbTNJ8wtmwA= Received: by 10.115.90.1 with SMTP id s1mr8410332wal.1183659289543; Thu, 05 Jul 2007 11:14:49 -0700 (PDT) Received: by 10.114.111.12 with HTTP; Thu, 5 Jul 2007 11:14:49 -0700 (PDT) Message-ID: Date: Thu, 5 Jul 2007 14:14:49 -0400 From: "Sibte Abbas" To: "Jessica Richard" Subject: Re: how to get a list of members of a postgres group? Cc: pgsql-admin@postgresql.org In-Reply-To: <384522.53334.qm@web56415.mail.re3.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <384522.53334.qm@web56415.mail.re3.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/50 X-Sequence-Number: 26031 On 7/5/07, Jessica Richard wrote: > Creatred a group, added members to the group, what command to use to check > the current members in the group? thanks. > > You can query group related information from the pg_group view. The 'grolist' parameter would contain an array of the sysid's of all its members. regards, -- Sibte Abbas EnterpriseDB http://www.enterprisedb.com