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?
