pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedShowing all groups
3+ messages / 3 participants
[nested] [flat]
* Showing all groups
@ 2004-02-12 16:09 Eric <hehe88hk@yahoo.com.hk>
2004-02-12 22:01 ` Re: Showing all groups Mike Johnson <dev_mrjohnson@trinitycapital.com>
2004-02-13 00:53 ` Re: Showing all groups Fred Moyer <fred@redhotpenguin.com>
0 siblings, 2 replies; 3+ messages in thread
From: hehe88hk@yahoo.com.hk @ 2004-02-12 16:09 UTC (permalink / raw)
To: pgsql-admin
In PostGres, we can show all existing users by "\du".
However, how to show all existing groups?
Thanks
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Showing all groups
2004-02-12 16:09 Showing all groups Eric <hehe88hk@yahoo.com.hk>
@ 2004-02-12 22:01 ` Mike Johnson <dev_mrjohnson@trinitycapital.com>
1 sibling, 0 replies; 3+ messages in thread
From: Mike Johnson @ 2004-02-12 22:01 UTC (permalink / raw)
To: Eric <hehe88hk@yahoo.com.hk>; +Cc: pgsql-admin
you can simply:
select * from pg_group;
On Thu, 2004-02-12 at 08:09, Eric wrote:
> In PostGres, we can show all existing users by "\du".
> However, how to show all existing groups?
> Thanks
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Showing all groups
2004-02-12 16:09 Showing all groups Eric <hehe88hk@yahoo.com.hk>
@ 2004-02-13 00:53 ` Fred Moyer <fred@redhotpenguin.com>
1 sibling, 0 replies; 3+ messages in thread
From: Fred Moyer @ 2004-02-13 00:53 UTC (permalink / raw)
To: Eric <hehe88hk@yahoo.com.hk>; +Cc: pgsql-admin
> In PostGres, we can show all existing users by "\du".
> However, how to show all existing groups?
> Thanks
select * from pg_group;
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2004-02-13 00:53 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-02-12 16:09 Showing all groups Eric <hehe88hk@yahoo.com.hk>
2004-02-12 22:01 ` Mike Johnson <dev_mrjohnson@trinitycapital.com>
2004-02-13 00:53 ` Fred Moyer <fred@redhotpenguin.com>
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