220
edits
Changes
Jump to navigation
Jump to search
no edit summary
--1
After the Undisclosed company names are updated, you will need to recreate the companybase and roundbase tables.
Copy all the undisclosed companies to a text file and pull out the company names from the description.
DROP TABLE undisclosedcompanies
CREATE TABLE undisclosedcompanies AS
SELECT coname, description, url FROM roundbase
WHERE coname = 'Undisclosed Company';
--37
\COPY undisclosedcompanies TO 'undisclosedcompanies.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV;
