Changes

Retrieving US VC Data From SDC (view source)

350 bytes added , 10:52, 21 June 2017

\COPY firmbase FROM 'VCFirms1980-present-normal.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV

==Company Long Description==

DROP TABLE longdescription;

CREATE TABLE longdescription (

coname varchar(255),

statecode varchar(10),

fundingdate date, -- Date Company Received First Investment

codescription varchar(10000) --long description

);

\COPY longdescription FROM 'ResultOut.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV

--44793

220

edits