pg_user and pg_group

From: q u a d r a <quadratini(at)sni(dot)ph>
To: pgsql-sql(at)postgresql(dot)org
Subject: pg_user and pg_group
Date: 2002-06-28 17:32:23
Message-ID: 3D1C9DA7.7020901@sni.ph
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

Browse pgsql-sql by date

  From Date Subject
Next Message terry 2002-06-28 18:12:40 Re: graphical interface - admin
Previous Message Joseph Syjuco 2002-06-28 16:58:06 transaction in plpgsql