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 по дате отправления: