root/inputs/VegBank/taxonobservation_/postprocess.sql @ 11022
| 1 | 10932 | aaronmk | SELECT util.search_path_append('util'); |
|---|---|---|---|
| 2 | |||
| 3 | |||
| 4 | SELECT mk_derived_col((:table_str, 'scientificName'), |
||
| 5 | 10943 | aaronmk | $$_alt("scientificName_verbatim", "scientificName__for_nearest_taxon_concept")$$) |
| 6 | 10933 | aaronmk | ; -- runtime: 15 s ("Time: 12334.893 ms") @starscream |
| 7 | 10993 | aaronmk | |
| 8 | |||
| 9 | 10998 | aaronmk | SELECT create_if_not_exists($$ALTER TABLE $$||:table_str||$$ ADD PRIMARY KEY ("identificationID")$$); -- runtime: 1 s ("Time: 1342.115 ms") @starscream |