root/inputs/FIA/REF_UNIT/postprocess.sql @ 11396
| 1 | 10084 | aaronmk | SELECT util.search_path_append('util'); |
|---|---|---|---|
| 2 | 8163 | aaronmk | |
| 3 | 8184 | aaronmk | SELECT set_col_types('"REF_UNIT"', ARRAY[ |
| 4 | 10054 | aaronmk | ('*STATECD', 'integer') |
| 5 | , ('*UNITCD', 'integer') |
||
| 6 | 8184 | aaronmk | ]::col_cast[]); |
| 7 | 8126 | aaronmk | |
| 8 | 10054 | aaronmk | SELECT create_if_not_exists($$ALTER TABLE "REF_UNIT" ADD CONSTRAINT "REF_UNIT.unique" UNIQUE ("*STATECD", "*UNITCD")$$); |