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 621CCD1D36C for ; Thu, 12 Feb 2004 22:01:42 +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 17663-08 for ; Thu, 12 Feb 2004 18:01:40 -0400 (AST) Received: from union.trinitycapital.com (union.trinitycapital.com [204.156.146.226]) by svr1.postgresql.org (Postfix) with ESMTP id D8198D1D25D for ; Thu, 12 Feb 2004 18:01:37 -0400 (AST) Received: from coit.trinitycapital.com (coit.trinitycapital.com [38.230.46.40]) by union.trinitycapital.com (Postfix) with ESMTP id DA0F010A593; Thu, 12 Feb 2004 14:01:34 -0800 (PST) Received: from rose.trinitycapital.com ([38.230.46.44]) by coit.trinitycapital.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2653.13) id 1D8PQXYK; Thu, 12 Feb 2004 14:01:35 -0800 Received: by rose.trinitycapital.com (Postfix, from userid 1000) id 43FBB1464B; Thu, 12 Feb 2004 14:01:25 -0800 (PST) Subject: Re: Showing all groups From: Mike Johnson To: Eric Cc: pgsql-admin@postgresql.org In-Reply-To: References: Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1076623285.29850.21.camel@rose.trinitycapital.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 Date: Thu, 12 Feb 2004 14:01:25 -0800 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/191 X-Sequence-Number: 12365 you can simply: select * from pg_group; On Thu, 2004-02-12 at 08:09, Eric wrote: > In PostGres, we can show all existing users by "\du". > However, how to show all existing groups? > Thanks > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org