pg_user and pg_group
| От | q u a d r a |
|---|---|
| Тема | pg_user and pg_group |
| Дата | |
| Msg-id | 3D1C9DA7.7020901@sni.ph обсуждение исходный текст |
| Список | 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.
В списке pgsql-sql по дате отправления: