Re:Selecting All Columns Except One in PostgreSQL
by blattimwind on Saturday May 19, 2018 @10:36AM
(#17108039)
Writing "SELECT *" makes it less clear what columns are selected exactly. Explicitly writing what columns shall be returned is more explicit and clear.
[ Parent
| on HN ]
Re:Selecting All Columns Except One in PostgreSQL
by MichaelApproved on Saturday May 19, 2018 @11:08AM
(#17108165)
That's helpful from a code review perspective but it's the performance hit you get with a * select that is the bigger reason to avoid it.