root/inputs/FIA/REF_SPECIES/postprocess.sql @ 10296
| 1 | 10084 | aaronmk | SELECT util.search_path_append('util'); |
|---|---|---|---|
| 2 | 8163 | aaronmk | |
| 3 | 8184 | aaronmk | SELECT set_col_types('"REF_SPECIES"', ARRAY[ |
| 4 | 10054 | aaronmk | ('*SPCD', 'integer') |
| 5 | 8184 | aaronmk | ]::col_cast[]); |
| 6 | 8112 | aaronmk | |
| 7 | 10072 | aaronmk | SELECT mk_const_col(('"REF_SPECIES"', '*PLANT_SYMBOL_TYPE'), 'Species'::text); |
| 8 | 8127 | aaronmk | |
| 9 | 10054 | aaronmk | SELECT create_if_not_exists($$ALTER TABLE "REF_SPECIES" ADD CONSTRAINT "REF_SPECIES.unique" UNIQUE ("*SPCD")$$); |