pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Showing all groups
3+ messages / 3 participants
[nested] [flat]

* Showing all groups
@ 2004-02-12 16:09  Eric <hehe88hk@yahoo.com.hk>
  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 22:01  Mike Johnson <dev_mrjohnson@trinitycapital.com>
  parent: Eric <hehe88hk@yahoo.com.hk>
  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-13 00:53  Fred Moyer <fred@redhotpenguin.com>
  parent: Eric <hehe88hk@yahoo.com.hk>
  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