From: q u a d r a <quadratini@sni.ph>
To: pgsql-sql@postgresql.org
Subject: pg_user and pg_group
Date: Sat, 29 Jun 2002 01:32:23 +0800
Message-ID: <3D1C9DA7.7020901@sni.ph> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: quadratini@sni.ph
Subject: Re: pg_user and pg_group
In-Reply-To: <3D1C9DA7.7020901@sni.ph>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox