root/inputs/VegBank/taxonobservation_/postprocess.sql @ 11456
1 | 10932 | aaronmk | SELECT util.search_path_append('util'); |
---|---|---|---|
2 | |||
3 | 11232 | aaronmk | SELECT create_if_not_exists($$CREATE INDEX $$||:table_str||%'__parent'||$$ ON $$||:table_str||$$ ("eventID")$$); -- runtime: 2 s ("2416.676 ms") @starscream |
4 | 10932 | aaronmk | |
5 | 10998 | aaronmk | SELECT create_if_not_exists($$ALTER TABLE $$||:table_str||$$ ADD PRIMARY KEY ("identificationID")$$); -- runtime: 1 s ("Time: 1342.115 ms") @starscream |