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
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