Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The Database Command in the PostgreSQL Execute action looks like:

BEGIN;
INSERT INTO final_table (id, date)
SELECT id, date FROM staging_table
ON CONFLICT (id) DO UPDATE
SET date = excluded.date;
TRUNCATE staging_table;
COMMIT;

...