Well this is my first post to this list, so be gentle ;-).  With it I hope
we will be able to do most group amin, without going into psql.  It has
the following syntax:

usage: pg_group options -- dB group [user ...] || [table ...]
where options is one of:
 -c create group
 -d delete group
 -a add user(s) to group
 -r remove user(s) to group
 +g give group access to tables
 -g revoke group access to tables
 -p privlages to grant/revoke. This is only used with the +g and -g
options.
 -- end of switches.

 examples:
 pg_group -c -- guestbook grp_gstbook_usr nobody tux
 pg_group -a -- guestbook grp_gstbook_usr webuser
 pg_group -d -- guestbook grp_gstbook_usr
 pg_group -r -- guestbook grp_gstbook_usr nobody
 pg_group +g -p "insert,select" -- guestbook grp_gstbook_usr gstbook
 pg_group -g -p "insert" -- guestbook grp_gstbook_usr gstbook

I have attched the pg_group script src (it's in tcl), I hope It will make
it and it was not a bad thing to do so, if not you can get it from:
http://www.lowcountry.com/~jscottb/pg_group.tar.gz

If you have any questions, comments, patches or total rewrites email me
at: jscottb@infoave.com

scott
Fri, 10 Dec 1999 09:49:15 -0500 (EST)
jscottb@www.lowcountry.com
First draft of pg_group admin tool.