Alaska Software Inc. - Update table structure
Username: Password:
AuthorTopic: Update table structure
Simone Degl'InnocentiUpdate 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