Showing all groups

[Eric]

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

[Mike Johnson]

you can simply:

select * from pg_group;

Post by Eric
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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Fred Moyer]

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

select * from pg_group;

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend