Re: Restoring default privileges on objects

> On 29/08/2023 18:43 CEST Stuart McGraw <smcg4191@mtneva.com> wrote:
>
> How does one distinguish between (blank)=(default privileges)
> and (blank)=(no privileges)?
>
> Shouldn't psql put *something* (like "(default)" or "-") in the
> "Access privileges" column to indicate that?  Or conversely,
> something (like "(none)"?) in the revoked case?
>
> It doesn't seem like a good idea to use the same visual
> representation for two nearly opposite conditions.  It confused
> the heck out of me anyway... :-)

Indeed, that's confusing.  Command \dp always prints null as empty string [1].
So \pset null '(null)' has no effect.

The docs don't mention that edge case [2] (the second to last paragraph):

    "If the “Access privileges” column is empty for a given object, it
     means the object has default privileges (that is, its privileges
     entry in the relevant system catalog is null)."

[1]
https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/bin/psql/describe.c;h=bac94a338cfbc497200f0cf960cbabce2dadaa33;hb=9b581c53418666205938311ef86047aa3c6b741f#l1149
[2] https://www.postgresql.org/docs/14/ddl-priv.html

--
Erik