This is kind of a stupid question but I see lot of people here recommend postgresql so I decided to give it a try.<p>I stumbled upon the fact that it's not possible to rearrange columns ordering.<p>Is this not too much of a constraint ?
I mean what's the workaround for eg for the analysts using it daily ?
Columns just pile at the end of every table without any consistency ?<p>Sorry for the broken english (french)
The order of the columns in your table creation statements is irrelevant to the order of how the columns return to you in your queries.<p>Your select statement specified the order of your result columns in your result set. Your visualization tools should have the option to reorder the displayed columns to your liking or need.