Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id D43604771A7 for ; Fri, 28 Jun 2002 13:39:10 -0400 (EDT) Mailbox-Line: From quadratini@sni.ph Fri Jun 28 13:39:10 2002 Received: from ns.sni.ph (ns.sni.ph [210.23.103.9]) by postgresql.org (Postfix) with ESMTP id AA5E7477260 for ; Fri, 28 Jun 2002 13:26:18 -0400 (EDT) Received: (from root@localhost) by ns.sni.ph (8.11.6/8.11.6) id g5SHQHP93610 for pgsql-sql@postgresql.org; Sat, 29 Jun 2002 01:26:17 +0800 (PHT) Received: from sni.ph ([210.23.103.26]) by ns.sni.ph (8.11.6/8.11.6) with ESMTP id g5SHQG293545 for ; Sat, 29 Jun 2002 01:26:16 +0800 (PHT) Message-ID: <3D1C9DA7.7020901@sni.ph> Date: Sat, 29 Jun 2002 01:32:23 +0800 From: q u a d r a User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:0.9.4) Gecko/20011019 Netscape6/6.2 X-Accept-Language: en-us MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: pg_user and pg_group X-scanner: scanned by SNI 1.0.10 - (http://www.sni.ph) Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Spam-Status: No, hits=0.0 required=5.0 tests=none version=2.30 X-Spam-Level: X-Archive-Number: 200206/398 X-Sequence-Number: 8363 How can I select all users and their respective groups and then have them grouped by their group names? xxcafe=> select * from pg_user; usename | usesysid | usecreatedb | usetrace | usesuper | usecatupd | passwd | valuntil ----------+----------+-------------+----------+----------+-----------+----------+---------- user1 | 100 | f | f | f | f | ******** | user2 | 101 | f | f | f | f | ******** | user3 | 102 | f | f | f | f | ******** | xxcafe=> select * from pg_group; groname | grosysid | grolist ------------------+----------+--------- xxselectgroup | 100 | {100,101,102} xxdeletegroup | 101 | {100} xxupdategroup | 102 | {100,101} xxinsertgroup | 103 | {100,101} usesysid=grolist? Please help. Thank you very much.