| Reviewing database normal forms might be helpful/useful. [1] 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-... |