Revision 10947
Added by Aaron Marcuse-Kubitza about 11 years ago
| postprocess.sql | ||
|---|---|---|
| 6 | 6 |
, ('*COUNTYCD', 'integer')
|
| 7 | 7 |
]::col_cast[]); |
| 8 | 8 |
|
| 9 |
SELECT create_if_not_exists($$ALTER TABLE "COUNTY" ADD CONSTRAINT "COUNTY.ID" UNIQUE ("*COUNTY-CN")$$);
|
|
| 9 |
SELECT create_if_not_exists($$ALTER TABLE "COUNTY" ADD CONSTRAINT "COUNTY.ID" UNIQUE ("*COUNTY--CN")$$);
|
|
| 10 | 10 |
SELECT create_if_not_exists($$ALTER TABLE "COUNTY" ADD CONSTRAINT "COUNTY.unique" UNIQUE ("*STATECD", "*UNITCD", "*COUNTYCD")$$);
|
Also available in: Unified diff
inputs/FIA/*/map.csv: use -- to separate the table and column name instead of - , to conform with the u-name format (wiki.vegpath.org/u-name#format), which works even when only one of _- can be used in the name. -s are needed in this case to linewrap the column on a separate line as the table in phpPgAdmin.