Showing all groups

Поиск
Список
Период
Сортировка
Искать

Showing all groups

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

Re: Showing all groups

От:
Mike Johnson <dev_mrjohnson@trinitycapital.com>
Дата:
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

От:
"Fred Moyer" <fred@redhotpenguin.com>
Дата:
> In PostGres, we can show all existing users by "\du".
> However, how to show all existing groups?
> Thanks

select * from pg_group;
FAQ