Re: Missing array support

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>, Joe Conway <mail(at)joeconway(dot)com>
Subject: Re: Missing array support
Date: 2003-06-29 00:55:20
Message-ID: 23324.1056848120@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> Btw., it would be really nice if some limited form of this could get done,
> so I could finish the information schema views pertaining to group
> privileges. I'd just need a way to find out what users are in what
> groups.

As of a few minutes ago,

SELECT g.groname FROM pg_user u, pg_group g
WHERE u.usesysid = ANY (g.grolist) AND u.usename = current_user;

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joe Conway 2003-06-29 01:02:05 CVS tip compile failure (was Re: Missing array support)
Previous Message Andreas Pflug 2003-06-29 00:12:36 Re: pg_get_triggerdef in pg_dump

Browse pgsql-patches by date

  From Date Subject
Next Message Joe Conway 2003-06-29 01:02:05 CVS tip compile failure (was Re: Missing array support)
Previous Message Joe Conway 2003-06-28 21:11:46 Re: Missing array support