Revision 8111
Added by Aaron Marcuse-Kubitza almost 12 years ago
| postprocess.sql | ||
|---|---|---|
| 17 | 17 |
]::functions.col_cast[]); |
| 18 | 18 |
|
| 19 | 19 |
SELECT functions.create_if_not_exists($$ALTER TABLE "SUBPLOT" ADD CONSTRAINT "SUBPLOT.unique" UNIQUE (".STATECD", ".UNITCD", ".COUNTYCD", ".PLOT", ".INVYR", ".SUBP")$$);
|
| 20 |
SELECT functions.cluster_once(:table_str, '"SUBPLOT.unique"'); |
|
Also available in: Unified diff
inputs/FIA/*/postprocess.sql: Cluster tables by their *.unique index for faster joins