I stumbled upon the fact that it's not possible to rearrange columns ordering.
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 ?
Sorry for the broken english (french)
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.
verbal examples : discussion on various ways to reorder columns : https://stackoverflow.com/questions/1605144/how-to-change-co...
https://www.quackit.com/sql/tutorial/sql_order_by.cfm
Non-postgress, old school method:
1) Dump table data to ascii delimited file.
2) Use awk/gawk to re-arrange columns in ascii delimited file.
3) drop old data table.
4) create new data table to upload the awk/gawk data generated in #2.
5) upload awk/gawk data from #2.
--------
google translate might be helpful : https://translate.google.com/
[1] : https://www.geeksforgeeks.org/first-normal-form-1nf/?ref=lbp
few other related links, as some things get lost when translating between languages.
https://www.linkedin.com/learning/programming-foundations-da...
https://www.cs.dartmouth.edu/~cs61/Resources/Papers/CACM%20K...
https://www.i-programmer.info/babbages-bag/292-codd-and-his-...
awk: the power and promis of a 40 yr old language (2021) : https://www.fosslife.org/awk-power-and-promise-40-year-old-l...
Gawk: Effective AWK programming https://www.gnu.org/software/gawk/manual/
gawk-psql : pgsql extension of GNU awk : https://gawkextlib.sourceforge.net/pgsql/pgsql.html
gawkextlib : http://shouce.jb51.net/gawk/gawkextlib.html
gawk libraries for XML, PostgreSQL : https://osdn.net/projects/sfnet_gawkextlib/
psql : https://www.tutorialspoint.com/unix_commands/psql.htm
postgresql copy from program : https://stackoverflow.com/questions/62254888/using-awk-and-p...
user-defined modules to postgres : https://www.highgo.ca/2019/10/01/a-guide-to-create-user-defi...