Re:Postgres 15 improves UNIQUE and NULL
by iruoy on Monday July 11, 2022 @08:35AM
(#32055318)
I like to have my `*_id` columns at the front, and `created_at` etc. at the back. And in the middle all the fields by descending importance. Just a personal habit so I can quickly lookup data in a table.
[ Parent
| on HN ]
I'm totally with you on this, and would love to be able to directly reorder the columns in the tables.
A possible workaround is to have a view for every table (which I often read is a good practice anyway) and order the columns as you want in the views.
Exactly... You gain so much speed by having everything in the right order.
This seems pretty voodoo to me. Do you have any examples that show it?