Changes
Jump to navigation
Jump to search
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==
