Erik Wienhold <ewie@xxxxxxxxx> writes: > On 29/08/2023 18:43 CEST Stuart McGraw <smcg4191@xxxxxxxxxx> 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
