Hi list,

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...

bye,

Heiko

--
To err is human, to forgive, beyond the scope of the (Operating) System.

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

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/

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match