Updating the Data

After having loaded the data from May, let’s say that we’ve received an update for June. As usual, with updates of this kind, we don’t have a diff; rather, we have a whole new file with new content.

A batch update operation is typically implemented in this way:

• Load the new version of the data from the file to a PostgreSQL table or a temporary table.

• Use the update command ability to use join operations to update existing data with the new values.

• Use the insert command ...