root/inputs/FIA/REF_SPECIES/import @ 9667
1 |
#!/bin/bash
|
---|---|
2 |
# :mode=transact-sql:
|
3 |
cd "$(dirname "$0")" |
4 |
. ../../../lib/import.sh
|
5 |
|
6 |
map_table |
7 |
psql <<'EOF' |
8 |
SELECT set_col_types('"REF_SPECIES"', ARRAY[
|
9 |
('SPCD', 'integer')
|
10 |
]::col_cast[]);
|
11 |
|
12 |
SELECT mk_const_col(('"REF_SPECIES"', 'PLANT_SYMBOL_TYPE'), 'Species'::text);
|
13 |
|
14 |
SELECT create_if_not_exists($$ALTER TABLE "REF_SPECIES" ADD CONSTRAINT "REF_SPECIES.unique" UNIQUE ("SPCD")$$); |
15 |
EOF
|
16 |
mk_derived |