Thread: adding users to a group

On Fri, 26 Nov 1999, J. Roeleveld wrote:

> Hi,
>
> how can I add existing users to a group?

Example (add user 'gogo' to  group 'mygr'):

        ALTER USER gogo WITH PASSWORD "QwEr" IN GOUP mygr;

    SELECT * FROM pg_user;
    -----> see usesysid for 'gogo'

    UPDATE pg_group SET grolist='{1000}' WHERE groname='mygr';
    ------> where 1000 is usesysid for 'gogo'
                (for more users in one group: '{1000,1001, .. }'


It is a little terrible, because this is incomplete in the PgSQL. (All it
is probably job for a ALTER/CREATE USER, but in the current PgSQL still
not). In version 7.0?

                            Karel