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

pg_group system table

From: Gordon Clarke <gordonc(at)acenet(dot)net(dot)au>
To: pgsql-sql(at)postgresql(dot)org
Subject: pg_group system table
Date: 2000-02-14 21:13:50
Message-ID: Pine.LNX.4.10.10002141137470.2282-100000@localhost.localdomain (view raw, whole thread or download thread mbox)
Lists: pgsql-sql
The pgsql doco mentions that there is no create group command, at least in
v6.5.2. Further, that one needs to insert directly into the system table
pg_group which is fine. 

So I retrieved the user id's I needed from pg_user and made the following

insert into pg_group(groname, grosysid, grolist)

Now I want to determine which group(s) a certain user is in. So I tried.

select groname from pg_group pg
where pg.grolist{} = 101;

Which doesn't work, nor does..

select groname from pg_group pg
where pg.grolist[] = 101;

As well as many other combinations I tried. Too many to list and I'm
obviously on the wrong path.

However, provided I know where that user id is in the list ie. second, the
query works. This is not what I want because I'm not necessarily going to
know where that user id is in the list. So how do I write the query in a
general way given just the user id and not its position?

A way around is to make 3 entries for the above insert and therefore the
user id will always be the first and only item in the list, but I don't
want to have to resort to that.

~~~~~~~~~~~~~~ 4ZzZ Brisbane's First Community FM Station ~~~~~~~~~~~~~~
         The Demo Show - Supporting Australian Unsigned Artists
            Mon nights 6-7pm (0800-0900UTC) on 4ZzZ 102.1 FM
         (RA feed)

pgsql-sql by date

Next:From: ClayDate: 2000-02-15 00:31:48
Subject: is there a mysql to postgresql sql converter?
Previous:From: Mark VolpeDate: 2000-02-14 20:10:59
Subject: check_foreign_key with OIDs

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