Alaska Software Inc. - Update table structure

	Author	Topic: Update table structure
	Simone Degl'Innocenti	Update table structure on Wed, 23 Jun 2021 20:33:22 +0200 Hi 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

Author

Topic: Update table structure

Update table structure
on Wed, 23 Jun 2021 20:33:22 +0200

Hi

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