Re:Selecting All Columns Except One in PostgreSQL
by teej on Saturday May 19, 2018 @10:43AM
(#17108073)
Lots and lots of uses for this feature. I often wish I had it in Redshift.
[ Parent
| on HN ]
Re:Selecting All Columns Except One in PostgreSQL
by jlgaddis on Saturday May 19, 2018 @05:21PM
(#17109800)
I suppose it could be useful for keeping your "breach notification team" busy, after somebody (for whatever reason) adds a "users.hiv_positive" (boolean) column or some such and that column ends up being included somewhere you didn't intend it to be.
"Root cause analysis: The {database administrators|programmers} were too lazy to explicitly define the column names they wanted, resulting in the unintended disclosure of HIV positive status of $bignum individuals."