Revision 8093
Added by Aaron Marcuse-Kubitza over 11 years ago
| postprocess.sql | ||
|---|---|---|
| 1 |
SELECT functions.create_if_not_exists($$ALTER TABLE "COND" ADD CONSTRAINT "COND.unique" UNIQUE ("STATECD", "UNITCD", "COUNTYCD", "PLOT", "INVYR", "CONDID")$$);
|
|
| 1 |
SELECT functions.to_global_col_names(:table_str); |
|
| 2 |
|
|
| 3 |
SELECT functions.create_if_not_exists($$ALTER TABLE "COND" ADD CONSTRAINT "COND.unique" UNIQUE ("COND.STATECD", "COND.UNITCD", "COND.COUNTYCD", "COND.PLOT", "COND.INVYR", "COND.CONDID")$$);
|
|
Also available in: Unified diff
inputs/FIA/*/postprocess.sql: Use functions.to_global_col_names() to ensure that all column names are globally unique. This makes it easy to join the tables together without worrying about column name collisions.