Revision 6046
Added by Aaron Marcuse-Kubitza over 11 years ago
vegbien.sql | ||
---|---|---|
488 | 488 |
|
489 | 489 |
|
490 | 490 |
-- |
491 |
-- Name: make_analytical_db(); Type: FUNCTION; Schema: public; Owner: - |
|
492 |
-- |
|
493 |
|
|
494 |
CREATE FUNCTION make_analytical_db() RETURNS void |
|
495 |
LANGUAGE sql |
|
496 |
AS $$ |
|
497 |
SELECT make_family_higher_plant_group(); |
|
498 |
|
|
499 |
TRUNCATE analytical_stem; |
|
500 |
INSERT INTO analytical_stem SELECT * FROM analytical_stem_view; |
|
501 |
TRUNCATE analytical_aggregate; |
|
502 |
INSERT INTO analytical_aggregate SELECT * FROM analytical_aggregate_view; |
|
503 |
TRUNCATE geoscrub_input; |
|
504 |
INSERT INTO geoscrub_input SELECT * FROM geoscrub_input_view; |
|
505 |
$$; |
|
506 |
|
|
507 |
|
|
508 |
-- |
|
509 | 491 |
-- Name: make_family_higher_plant_group(); Type: FUNCTION; Schema: public; Owner: - |
510 | 492 |
-- |
511 | 493 |
|
Also available in: Unified diff
schemas/vegbien.sql: Removed no longer used make_analytical_db(). Use bin/make_analytical_db instead.