Skip site navigation (1) Skip section navigation (2)

Group Query

From: Rob Kirkbride <rob(at)rkcomputing(dot)co(dot)uk>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Group Query
Date: 2005-12-14 11:00:48
Message-ID: 439FFB60.9020806@rkcomputing.co.uk (view raw or flat)
Thread:
Lists: pgsql-jdbc
Hi,

It's probably because I'm struggling with array queries but how can I 
get the (textual) list of groups allocated to the current user?

I can get the current_user and extract the id out of pg_user, however I 
need to then match this to an element as part of a list in pg_group, 
this is the part I can't find how how to do. I'd like it as a ResultSet 
with each element with the textual group name

Thanks for any help,

Rob


Responses

pgsql-jdbc by date

Next:From: Rob KirkbrideDate: 2005-12-14 12:57:31
Subject: Re: Group Query
Previous:From: Thomas FrielingDate: 2005-12-14 10:56:54
Subject: CallableStatements: index starts at 2

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group