Revision 8208
Added by Aaron Marcuse-Kubitza over 11 years ago
| import | ||
|---|---|---|
| 16 | 16 |
SELECT create_if_not_exists($$ALTER TABLE "PLOT" ADD CONSTRAINT "PLOT.ID" UNIQUE ("locationID")$$);
|
| 17 | 17 |
SELECT create_if_not_exists($$ALTER TABLE "PLOT" ADD CONSTRAINT "PLOT.unique" UNIQUE ("STATECD", "UNITCD", "COUNTYCD", "locationName", "INVYR")$$);
|
| 18 | 18 |
SELECT cluster_once('"PLOT"', '"PLOT.unique"');
|
| 19 |
EOF |
|
| 20 |
mk_derived |
|
Also available in: Unified diff
inputs/FIA/*/import: Run mk_derived after postprocessing commands