[rangerelf]

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.

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.

[sargstuff]

visual example : https://www.w3resource.com/sql-exercises/sql-retrieve-exerci...

verbal examples : discussion on various ways to reorder columns : https://stackoverflow.com/questions/1605144/how-to-change-co...

[HNBRN]

Thanks. I checked and dbeaver can indeed store columns ordering as a filtered view. Seems like a bit overcomplicated to me but I guess I've been spoiled with mysql in which the ordering is trivial.