Re: Access privileges

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Heiko <hero(at)persua(dot)de>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Access privileges
Date: 2005-02-16 19:14:26
Message-ID: 20050216191426.GA19660@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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/

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2005-02-16 20:05:17 Re: Postgres crashed on invalid IP entry in pg_hba.conf
Previous Message pkalva 2005-02-16 18:36:26 Postgres crashed on invalid IP entry in pg_hba.conf