select all groups a user belongs to in system tables

From: Uwe Feldtmann <uwe(at)microshare(dot)com(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: select all groups a user belongs to in system tables
Date: 2002-08-03 08:22:54
Message-ID: 3D4B92DE.5050802@microshare.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message HT&T 2002-08-03 08:55:16 Re: MySQL or Postgres ?
Previous Message Neil Conway 2002-08-03 04:57:35 Re: varchar truncation from 7.1 to 7.2