select all groups a user belongs to in system tables - Mailing list pgsql-general

From Uwe Feldtmann
Subject select all groups a user belongs to in system tables
Date
Msg-id 3D4B92DE.5050802@microshare.com.au
Whole thread Raw
List 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 by date:

Previous
From: nconway@klamath.dyndns.org (Neil Conway)
Date:
Subject: Re: varchar truncation from 7.1 to 7.2
Next
From: Ralph Graulich
Date:
Subject: SQL logic for version history including table