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