-- contains the research station *and state name* for each state

SELECT functions.to_global_col_names(:table_str);

SELECT functions.rename_if_exists($$ALTER TABLE "REF_RESEARCH_STATION" RENAME "REF_RESEARCH_STATION.STATECD" TO ".STATECD"$$);

SELECT functions.set_col_types(:table_str, ARRAY[

  ('.STATECD' , 'integer')

]::functions.col_cast[]);

SELECT functions.create_if_not_exists($$ALTER TABLE "REF_RESEARCH_STATION" ADD CONSTRAINT "REF_RESEARCH_STATION.unique" UNIQUE (".STATECD")$$);