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.
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 |