Thread: Showing all groups

In PostGres, we can show all existing users by "\du".
However, how to show all existing groups?
Thanks

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

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

select * from pg_group;