pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedHow to get all users under a group
2+ messages / 1 participants
[nested] [flat]
* How to get all users under a group
@ 2006-09-12 19:24 Emi Lu <emilu@encs.concordia.ca>
2006-09-13 13:51 ` Re: How to get all users under a group Emi Lu <emilu@encs.concordia.ca>
0 siblings, 1 reply; 2+ messages in thread
From: Emi Lu @ 2006-09-12 19:24 UTC (permalink / raw)
To: pgsql-sql
Hello,
I know \du+ can get all group info for each user.
Could someone tell me how to get all users under each group please?
such as provide the group name, showing all users under the group.
Thanks,
Emi
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: How to get all users under a group
2006-09-12 19:24 How to get all users under a group Emi Lu <emilu@encs.concordia.ca>
@ 2006-09-13 13:51 ` Emi Lu <emilu@encs.concordia.ca>
0 siblings, 0 replies; 2+ messages in thread
From: Emi Lu @ 2006-09-13 13:51 UTC (permalink / raw)
To: pgsql-sql
To answer my own question:
SELECT g.groname , u.usename AS "User name"
FROM pg_catalog.pg_user u
left join pg_catalog.pg_group g on(u.usesysid = ANY(g.grolist))
ORDER BY 1, 2;
>
> I know \du+ can get all group info for each user.
>
> Could someone tell me how to get all users under each group please?
>
> such as provide the group name, showing all users under the group.
>
> Thanks,
> Emi
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2006-09-13 13:51 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-09-12 19:24 How to get all users under a group Emi Lu <emilu@encs.concordia.ca>
2006-09-13 13:51 ` Emi Lu <emilu@encs.concordia.ca>
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