Project

General

Profile

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")$$);
(7-7/10)