X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id EFEB7D1DA83 for ; Fri, 13 Feb 2004 00:53:51 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 80751-08 for ; Thu, 12 Feb 2004 20:53:52 -0400 (AST) Received: from redhotpenguin.com (c-24-7-81-19.client.comcast.net [24.7.81.19]) by svr1.postgresql.org (Postfix) with ESMTP id 4BEDED1DAFB for ; Thu, 12 Feb 2004 20:53:47 -0400 (AST) Received: (qmail 6739 invoked from network); 13 Feb 2004 00:53:49 -0000 Received: from localhost (HELO 127.0.0.1) (127.0.0.1) by localhost with SMTP; 13 Feb 2004 00:53:49 -0000 Received: from 127.0.0.1 (proxying for 24.7.81.19) (SquirrelMail authenticated user fred@redhotpenguin.com) by 127.0.0.1 with HTTP; Thu, 12 Feb 2004 16:53:49 -0800 (PST) Message-ID: <41601.127.0.0.1.1076633629.squirrel@127.0.0.1> In-Reply-To: References: Date: Thu, 12 Feb 2004 16:53:49 -0800 (PST) Subject: Re: Showing all groups From: "Fred Moyer" To: "Eric" Cc: pgsql-admin@postgresql.org Reply-To: fred@redhotpenguin.com User-Agent: SquirrelMail/1.4.2-1.qvcs.1 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 Importance: Normal X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.5 tagged_above=0.0 required=5.0 tests=BAYES_00, PRIORITY_NO_NAME, RCVD_IN_DYNABLOCK, RCVD_IN_SORBS, RCVD_NUMERIC_HELO X-Spam-Level: X-Archive-Number: 200402/197 X-Sequence-Number: 12371 > In PostGres, we can show all existing users by "\du". > However, how to show all existing groups? > Thanks select * from pg_group;