pg_group view

From: "Rob Abernethy IV" <abernethy(at)dynedge(dot)com>
To: "postgresql" <pgsql-admin(at)postgresql(dot)org>
Subject: pg_group view
Date: 2002-12-30 07:32:46
Message-ID: 20021230153246.M60737@dynedge.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Andreas Schmitz 2002-12-30 09:42:52 Re: dbsize
Previous Message Tony Ziolkowski 2002-12-29 20:06:34 postsgresql-dump not found in install