Changes

Jump to navigation Jump to search
333 bytes added ,  15:05, 6 August 2018
I encountered no problems loading in this data.
 
DROP TABLE longdescription;
CREATE TABLE longdescription(
varchar(255),
statecode varchar(10),
fundingdate date, --date co received first inv
codescription varchar(10000) --long description
);
 
\COPY longdescription FROM 'PortCoLongDesc-Ready-normal-fixed.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV
--48037
==Instructions on Matching PortCos to Issuers and M&As From Ed==
158

edits

Navigation menu