Revision 8316
Added by Aaron Marcuse-Kubitza over 11 years ago
| import | ||
|---|---|---|
| 11 | 11 |
, ('COUNTYCD', 'integer')
|
| 12 | 12 |
]::col_cast[]); |
| 13 | 13 |
|
| 14 |
SELECT create_if_not_exists($$ALTER TABLE "COUNTY" ADD CONSTRAINT "COUNTY.ID" UNIQUE ("COUNTY
|
|
| 15 |
CN")$$); |
|
| 14 |
SELECT create_if_not_exists($$ALTER TABLE "COUNTY" ADD CONSTRAINT "COUNTY.ID" UNIQUE ("COUNTY-CN")$$);
|
|
| 16 | 15 |
SELECT create_if_not_exists($$ALTER TABLE "COUNTY" ADD CONSTRAINT "COUNTY.unique" UNIQUE ("STATECD", "UNITCD", "COUNTYCD")$$);
|
| 17 | 16 |
EOF |
| 18 | 17 |
mk_derived |
Also available in: Unified diff
inputs/FIA/*/map.csv: Changed newlines between table and field name to - because the newlines mess up the flow of queries and also break pgAdmin's display of EXPLAIN output. The - was chosen because it's a non-whitespace character that linewraps in browsers, phpPgAdmin, and Google spreadsheets (although unfortunately not in pgAdmin). It is better than space because you can set a text editor to treat it as a word character, allowing the entire column name (<table>-<field>) to be selected by double-clicking it.