root/inputs/VegBank/taxonobservation_/postprocess.sql @ 11510
| 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 |