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.

--------

[1] : https://www.geeksforgeeks.org/first-normal-form-1nf/?ref=lbp

Thanks, we could definitely start from this

resources:

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...