procedure for updating the reference.scc table

[cseppan]

Prompted by a question about updates from MARAMA, need to review/develop a procedure for updates to the reference.scc table as inventories are developed.

[cseppan]

Export data from reference.scc and reference.scc_codes tables:

pg_dump -h localhost -U emf -a -t reference.scc EMF > reference.scc.sql
pg_dump -h localhost -U emf -a -t reference.scc_codes EMF > reference.scc_codes.sql

Load data:

TRUNCATE reference.scc;
ALTER TABLE reference.scc ALTER COLUMN map_to TYPE VARCHAR(2000);
ALTER TABLE reference.scc ALTER COLUMN scc_description TYPE VARCHAR(600);
\i reference.scc.sql

TRUNCATE reference.scc_codes;
ALTER TABLE reference.scc_codes ALTER COLUMN map_to TYPE VARCHAR(2000);
\i reference.scc_codes.sql