SQL script to update contacts with dotmailer IDs

gistfile1.txt

DROP TABLE IF EXISTS dm_temp;
CREATE TABLE dm_temp(
    id int unique not null,
    email varchar(256) unique not null,
    status varchar(64)
);
COPY dm_temp FROM '/tmp/contacts.csv' WITH CSV;
BEGIN;
    UPDATE mn set dotmailer_id=( select id from dm_temp where mn.eml=email);
COMMIT;