Changes

2) Load the file into the database

DROP TABLE ChosenShortOrgUUIDs;

CREATE TABLE ChosenShortOrgUUIDs (

uuid varchar(100)

);

\COPY ChosenShortOrgUUIDs FROM 'CrunchbaseShortOrgDescChosenByYi.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV

--275

DROP TABLE ChosenLongOrgUUIDs;

CREATE TABLE ChosenLongOrgUUIDs (

uuid varchar(100)

);

\COPY ChosenShortOrgUUIDs FROM 'CrunchbaseShortOrgDescChosenByLibby.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV

--301