root/inputs/FIA/REF_RESEARCH_STATION/postprocess.sql @ 10089
| 1 | 10084 | aaronmk | SELECT util.search_path_append('util'); |
|---|---|---|---|
| 2 | 8163 | aaronmk | |
| 3 | 8125 | aaronmk | -- contains the research station *and state name* for each state
|
| 4 | |||
| 5 | 8184 | aaronmk | SELECT set_col_types('"REF_RESEARCH_STATION"', ARRAY[ |
| 6 | 10054 | aaronmk | ('*STATECD', 'integer') |
| 7 | 8184 | aaronmk | ]::col_cast[]); |
| 8 | 8125 | aaronmk | |
| 9 | 10054 | aaronmk | SELECT create_if_not_exists($$ALTER TABLE "REF_RESEARCH_STATION" ADD CONSTRAINT "REF_RESEARCH_STATION.unique" UNIQUE ("*STATECD")$$); |