is a user in a group? - Mailing list pgsql-admin

From Jacopo Silva
Subject is a user in a group?
Date
Msg-id 002e01c04b22$89e177c0$3d01a8c0@sede.lynxtesoft.it
Whole thread Raw
Responses Re: is a user in a group?
List pgsql-admin
I need to find out a quick way to check which groups a user
is member of.

In the pg_group table each group row has an array of
userids of the members of the group.
At the moment I am selecting all the rows than
searching in each array for the id of the user
I am looking for.

There should be something more elegant than this!!!
There should be a system table which I can use to find
the relation between user and groups.

I would be very grateful to anyone who can help me:-).

Bye,
Jacopo





pgsql-admin by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: Implementing mod_perl, Perl 5.004, and Postgres
Next
From: Charlie Crissman
Date:
Subject: Does Postgres support Unicode (multibyte char set), NLS type func tionality...?