pg_group view - Mailing list pgsql-admin

From Rob Abernethy IV
Subject pg_group view
Date
Msg-id 20021230153246.M60737@dynedge.com
Whole thread Raw
Responses Re: pg_group view  (Joe Conway <mail@joeconway.com>)
List pgsql-admin
Does anyone have a good recipe for a view that will display users/gruops in a
way that can be used with Tomcat's JDBCRelam configuration?  In other words,
instead of seeing a *list* of users in a group (grolist), I'd like to see a
separate row for every group/user combination.

group | user
-------------
1     | 1
1     | 2
2     | 1

Instead of:

groname | grolist
------------------
1       | {1:2}
2       | {1}

--
Robert Abernethy IV
Dynamic Edge, Inc.
734.975.0460

pgsql-admin by date:

Previous
From: "Ing. Gabriel Monsalvo"
Date:
Subject: Get client's IP
Next
From: Joe Conway
Date:
Subject: Re: pg_group view