Revision 8093
Added by Aaron Marcuse-Kubitza almost 12 years ago
| postprocess.sql | ||
|---|---|---|
| 1 |
SELECT functions.create_if_not_exists($$ALTER TABLE "REF_SPECIES" ADD CONSTRAINT "REF_SPECIES.unique" UNIQUE ("SPCD")$$);
|
|
| 1 |
SELECT functions.to_global_col_names(:table_str); |
|
| 2 |
|
|
| 3 |
SELECT functions.create_if_not_exists($$ALTER TABLE "REF_SPECIES" ADD CONSTRAINT "REF_SPECIES.unique" UNIQUE ("REF_SPECIES.SPCD")$$);
|
|
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.