News for hackers. Stuff that matters.
Re:Reordering Columns in PostgreSQL by sargstuff on Thursday January 05, 2023 @04:15PM (#34266703)
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

There are no comments on this comment yet.