I need to ask about best practices. I now have periodic bulk CSV data
needing to be added to an existing table. I assume it is best to first move
the data into a temporary table & scrub it before moving into the final
table. However, the incoming data does not have the same schema as the
permanent target as additional attributes (columns) have been added. Is it
better to massage the temporary table into the same target's schema first, &
use COPY to copy all temporary contents into the permanent table, or is
scripting a better solution? Is there a better method?
Your insights would be appreciated.
Thanks.