Re: Restoring default privileges on objects

Erik Wienhold <ewie(at)ewie(dot)name> writes:
> On 29/08/2023 18:43 CEST Stuart McGraw <smcg4191(at)mtneva(dot)com> wrote:
>> 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?

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

Yeah, perhaps. The reason it so seldom comes up is that a state of
zero privileges is extremely rare (because it's useless in practice).

That being the case, if we were to do something about this, I'd vote
for changing the display of zero-privileges to "(none)" or something
along that line, rather than changing the display of NULL, which
people are accustomed to.

Fixing \dp to honor "\pset null" for this might be a reasonable
thing to do too. I'm actually a bit surprised that that doesn't
work already.

regards, tom lane