X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4F6338BAD0E for ; Wed, 16 Feb 2005 19:34:13 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 38768-08 for ; Wed, 16 Feb 2005 19:33:41 +0000 (GMT) Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158]) by svr1.postgresql.org (Postfix) with ESMTP id 2B2E48BA113 for ; Wed, 16 Feb 2005 19:14:34 +0000 (GMT) Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1]) by tigger.fuhr.org (8.13.1/8.13.1) with ESMTP id j1GJEQD3029805 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Wed, 16 Feb 2005 12:14:29 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: from winnie.fuhr.org (localhost [127.0.0.1]) by winnie.fuhr.org (8.13.1/8.13.1) with ESMTP id j1GJEQC6019729; Wed, 16 Feb 2005 12:14:26 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.1/8.13.1/Submit) id j1GJEQIq019728; Wed, 16 Feb 2005 12:14:26 -0700 (MST) (envelope-from mfuhr) Date: Wed, 16 Feb 2005 12:14:26 -0700 From: Michael Fuhr To: Heiko Cc: pgsql-admin@postgresql.org Subject: Re: Access privileges Message-ID: <20050216191426.GA19660@winnie.fuhr.org> References: <20050216140454.GA9064@mail.eidologic.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20050216140454.GA9064@mail.eidologic.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.003 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200502/147 X-Sequence-Number: 16315 On Wed, Feb 16, 2005 at 03:04:54PM +0100, Heiko wrote: > > I'm looking for a SQL command (SELECT) that returns me the > access rights like the psql \z does. I can't find anything > about it in the documentation. Thanks in advance... Run psql -E or do a \set ECHO_HIDDEN -- that'll show the queries that psql makes for \z, \d, etc. See also the "System Catalogs" chapter in the documentation. -- Michael Fuhr http://www.fuhr.org/~mfuhr/