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