Thread: Showing all groups

Showing all groups

From
hehe88hk@yahoo.com.hk (Eric)
Date:
In PostGres, we can show all existing users by "\du".
However, how to show all existing groups?
Thanks

Re: Showing all groups

From
Mike Johnson
Date:
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

Re: Showing all groups

From
"Fred Moyer"
Date:
> In PostGres, we can show all existing users by "\du".
> However, how to show all existing groups?
> Thanks

select * from pg_group;