root/inputs/HVAA/Specimen/postprocess.sql @ 10534
| 1 | 10532 | aaronmk | SELECT util.search_path_append('util'); |
|---|---|---|---|
| 2 | |||
| 3 | 10533 | aaronmk | SELECT util.rename_cols(:table_str, $$ |
| 4 | occurrenceRemarks => *occurrenceRemarks, |
||
| 5 | $$::hstore); |
||
| 6 | 10532 | aaronmk | |
| 7 | 10533 | aaronmk | |
| 8 | 10532 | aaronmk | SELECT mk_derived_col((:table_str, 'occurrenceRemarks'), |
| 9 | 10533 | aaronmk | $$_merge("*occurrenceRemarks", "dynamicProperties")$$) |
| 10 | 10532 | aaronmk | ; -- runtime: 1 s ("Time: 590.875 ms") @starscream |