Changes

Jump to navigation Jump to search
4 bytes removed ,  12:14, 17 May 2019
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
241

edits

Navigation menu