Changes

Harvard Dataverse (view source)

699 bytes added , 13:26, 6 April 2016

no edit summary

For more information about the patent data:

[[Patent Data]]

==Loading the tables into the database==

COPY classes FROM '/tmp/class.csv' DELIMITER ',' NULL '' CSV;

COPY assignees FROM '/tmp/assignee.csv' DELIMITER ',' NULL '' CSV;

COPY citations FROM '/tmp/citation.csv' DELIMITER ',' NULL '' CSV;

COPY inventors FROM '/tmp/inventor.csv' DELIMITER ',' NULL '' CSV;

COPY patents FROM '/tmp/patent.csv' DELIMITER ',' NULL '' CSV;

COPY patdescs FROM '/tmp/patdesc.csv' DELIMITER ',' NULL '' CSV;

COPY lawyers FROM '/tmp/lawyer.csv' DELIMITER ',' NULL '' CSV;

COPY scirefs FROM '/tmp/sciref.csv' DELIMITER ',' NULL '' CSV;

COPY usreldocs FROM '/tmp/usreldoc.csv' DELIMITER ',' NULL '' CSV;

COPY invpats FROM '/tmp/invpat.csv' DELIMITER ',' NULL '' CSV;

==Accessing the dbase==

Anonymous user