Update table structure
on Wed, 23 Jun 2021 20:33:22 +0200
I have migrated some projects from DBF to PostgreSQL with PGDBE
I have used dbfupsize for migrating all the data and structure.
Now I need to change the structure of the data inside PostgreSQL
To create or update index I can use a new create index, but to change the structure of the migrated data I can use dbfupsize or I can only make this using an ALTER TABLE?
The reason for this question is because I have received a new updated DBF and I must change the structure inside Postgre and I want to know the best practice, without lose all the data inside Postgre.
all the best