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