Received: from bologna.nettuno.it (bologna.nettuno.it [193.43.2.1]) by hub.org (8.8.8/8.8.8) with ESMTP id JAA27582 for ; Wed, 16 Sep 1998 09:35:03 -0400 (EDT) (envelope-from sferac@bo.nettuno.it) Received: from proxy.sferacarta.com (mail@sfcabop1.nettuno.it [193.207.10.213]) by bologna.nettuno.it (8.8.6/8.8.6/NETTuno 3.1) with ESMTP id PAA12084; Wed, 16 Sep 1998 15:35:00 +0200 (MDT) Received: from blu.sferacarta.com (mail.sferacarta.com) [10.20.30.12] by proxy.sferacarta.com with smtp (Exim 1.92 #1 (Debian)) id 0zJJUv-0005Z4-00; Wed, 16 Sep 1998 15:28:01 +0000 Date: Wed, 16 Sep 1998 15:35:08 +0200 From: Sferacarta Software X-Mailer: The Bat! (v1.017) UNREG Reply-To: Sferacarta Software Organization: Sferacarta Software Priority: Normal Message-ID: <3649.980916@bo.nettuno.it> To: pgsql-sql@postgresql.org, maloune Subject: Re: [SQL] create a new user in a group References: <35FFB02F.B940A1C2@cur-archamps.fr> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit 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'