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 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings