Re: [PATCH] Proposal for HIDDEN/INVISIBLE column - Mailing list pgsql-hackers

On Fri, Oct 15, 2021 at 9:40 PM Dave Cramer <davecramer@postgres.rocks> wrote:
>
> On Fri, 15 Oct 2021 at 09:29, Gilles Darold <gilles@migops.com> wrote:
>>
>> Yes, I don't wanted to offend you or to troll. This was just to point
>> that the position of "SELECT * is bad practice" is not a good argument
>> in my point of view, just because it is allowed for every one. I mean
>> that in an extension or a client which allow user query input we must
>> handle the case.
>
> This would break an awful lot of apps.

Which is also why allowing to hide some custom columns from a "SELECT
*" powerful.  It's no doubt a niche usage, but as Gilles mentioned
extensions can make use of that to build interesting things.  If DBA
can also make use of it to ease manual queries if the client apps are
correctly written, that's icing on the cake.