158
edits
Changes
Jump to navigation
Jump to search
→Loading Tables
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==
