SELECT util.search_path_append('util');

SELECT create_if_not_exists($$ALTER TABLE $$||:table_str||$$ ADD PRIMARY KEY (specimen_id)$$);

SELECT mk_derived_col((:table_str, 'occurrenceRemarks'),
$$CASE WHEN "Locality_Description" IS NOT NULL THEN "Notes_Plant" END$$)
; -- runtime: 0.3 s ("Time: 311.190 ms") @starscream
