POSTGRES: Load delimited file into table

-- ensure no null lines at end of file!

\copy substances (id, ec_number, cas_number, ec_name, mol_formula) 
from '/home/chemuser/chems.txt' DELIMITER '|';