Hello,
I have a table with many columns stored in a postGIS dB.
These include:
-transformed data
-data extracted from an oracle dB
The columns have been renamed and transformed in the PostGIS table.
There are a certain amount of columns I wish to update with data contained in a Oracle dB.
What is the best way to drop data in certain columns of my PostGIS table and repopulate it with data from the oracle dB?
Thank you
If the PostGIS table and the Oracle table have a common field which can be used as tables join key, remove the unnecessary fields from the PostGIS regords then merge the Oracle records with the FeatureMerger, using the common field as the Join On parameter.
If the PostGIS table and the Oracle table have a common field which can be used as tables join key, remove the unnecessary fields from the PostGIS regords then merge the Oracle records with the FeatureMerger, using the common field as the Join On parameter.
Thank you.
However, I am hoping to find a way which doesn't oblige me to drop the fields and recreate them, just repopulate them, as this will most likely result in slight changes in the data structure, which will block further data processing workflow.
I do have a common key.