Re: Reading privileges

From: GH <grasshacker(at)over-yonder(dot)net>
To: Kublai Khan <khan(at)ser(dot)fdns(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Reading privileges
Date: 2000-12-01 05:09:37
Message-ID: 20001130230937.B64111@over-yonder.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Nov 30, 2000 at 05:01:10PM -0800, some SMTP stream spewed forth:
> Hiho,
>
> How does one fetch the privileges on a PostgreSQL table from SQL? I'm
> looking for the SQL equivalent of psql's "\z". In Oracle, this would be
> "describe user_tab_priv".

I cannot tell you off the top of my head, but if you do `psql -E` it will
show the commands it uses for such things as \z, etc.

gh

>
> Thanks!
>
>
> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> -----== Over 80,000 Newsgroups - 16 Different Servers! =-----

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ed Loehr 2000-12-01 05:45:59 Closest SQL dialect to PostgreSQL for ERwin?
Previous Message Tom Lane 2000-12-01 04:46:18 Re: pltcl: missing close-brace