Re: CREATE GROUP question

On Thu, May 22, 2003 at 15:04:19 -0700,
  David Olbersen <DOlbersen@stbernard.com> wrote:
> Hello all,
>
> Looking at the documentation for 7.3 I see that I can create a group and populate it with users at the same time:
>
>   CREATE GROUP foo WITH USER joe, john, jane;
>
> Looking at the ALTER GROUP and CREATE GROUP documentation I only see "ADD|DROP USER" and "WITH USER" as options,
nothingto do with other groups. 
>
> What I'd like to do is create a group which contains groups.
> Can I do that at all? It doesn't look like it according to the documentation, and the question isn't raised. I tried
searchingthe list archives at:  
>   http://archives.postgresql.org/search.php
> but never got results back as my browser waited forever for ads.area902.com to respond. A quick search on
http://groups.google.comalso didn't find what I was looking for. 

The group commands doesn't allow for groups within groups. You can use
expressions of the usernames on the group commands so you can't directly
pull the data out of the database. What you could do is run a script
that extracts group information out of the database and then rebuild
the group lists. If you maintain the list in user tables you can even have
a trigger that would run a function that would rebuild the groups for
you. (You can't put triggers on system tables which is why the data needs
to be in a user table to do this.)