Russell Garner on Nostr: npub19lt42…6qfjk CREATE TEMPORARY TABLE staging_intervention ( concerns TEXT, ...

npub19lt4284mghqxekzm6n5njxurnxrxhqhrva2leusdsuu5ja5jeycq66qfjk (npub19lt…qfjk)

CREATE TEMPORARY TABLE staging_intervention (
concerns TEXT,
submitter TEXT
);

COPY staging_intervention
FROM STDIN
DELIMITER ',' CSV HEADER;

INSERT INTO intervention_items (concerns, submitter)
SELECT concerns, submitter
FROM staging_intervention
ON CONFLICT(concerns, submitter) DO NOTHING