select all groups a user belongs to in system tables

Поиск
Список
Период
Сортировка
От Uwe Feldtmann
Тема select all groups a user belongs to in system tables
Дата
Msg-id 3D4B92DE.5050802@microshare.com.au
обсуждение исходный текст
Список pgsql-general
Hi,

I'm new to sql and postgres and I am trying to create a query that will
return the list of groups a user belongs to.

As the grolist column in pg_group is an array is there a simple way to
return the list?

I've checked the array documentation and according to that document the
pg_group table should be redesigned.

Any assistance would be welcome. Thanks in advanced.


В списке pgsql-general по дате отправления:

Предыдущее
От: nconway@klamath.dyndns.org (Neil Conway)
Дата:
Сообщение: Re: varchar truncation from 7.1 to 7.2
Следующее
От: Ralph Graulich
Дата:
Сообщение: SQL logic for version history including table