-- Name: make_analytical_db(); Type: FUNCTION; Schema: public; Owner: -

--

--

-- Name: make_analytical_db(); Type: FUNCTION; Schema: public; Owner: -

--

CREATE FUNCTION make_analytical_db() RETURNS void

    LANGUAGE sql

    AS $$

SELECT make_family_higher_plant_group();

TRUNCATE analytical_stem;

INSERT INTO analytical_stem SELECT * FROM analytical_stem_view;

TRUNCATE analytical_aggregate;

INSERT INTO analytical_aggregate SELECT * FROM analytical_aggregate_view;

TRUNCATE geoscrub_input;

INSERT INTO geoscrub_input SELECT * FROM geoscrub_input_view;

$$;

--