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 <gil...@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.
