Re: [SQL] create a new user in a group - Mailing list pgsql-sql

Hello Maloune,

mercoledì, 16 settembre 98, you wrote:

m> i'd know how create a new user in a group, because when i do this
m> request
m> create user qwe in group this_group, i ont know where the group
m> information
m> are stored. i don't see their in pg_user or pg_group.
m> thanks.

m> --
m> a+
m> maloune

Currently, to create a GROUP you have to insert data manually into table pg_group as:

hygea=> INSERT INTO pg_group VALUES ('sfera',100);
INSERT 52704 1
hygea=> select * from pg_group;
groname|grosysid|grolist
-------+--------+-------
sfera  |     100|
(1 row)

hygea=> CREATE USER miriam IN GROUP sfera;
CREATE USER
hygea=> select * from pg_group;
groname|grosysid|grolist
-------+--------+-------
sfera  |     100|
(1 row)

hygea=> select usename, usesysid from pg_user;
usename |usesysid
--------+--------
postgres|    1009
miriam  |    1011
(2 rows)

Jose'