-- Name: set_col_names_with_metadata(regclass, regclass); Type: FUNCTION; Schema: util; Owner: -

--

CREATE FUNCTION set_col_names_with_metadata(table_ regclass, names regclass) RETURNS void

    LANGUAGE plpgsql STRICT

    AS $_$

DECLARE

	row_ util.map;

BEGIN

	FOR row_ IN

		EXECUTE $$DELETE FROM $$||names||$$ WHERE "from" LIKE ':%' RETURNING *$$

	LOOP

		PERFORM mk_const_col((table_, "to"), substring("from" from 1));

	END LOOP;

	PERFORM util.set_col_names(table_, names);

END;

$_$;

--

-- Name: FUNCTION set_col_names_with_metadata(table_ regclass, names regclass); Type: COMMENT; Schema: util; Owner: -

--

COMMENT ON FUNCTION set_col_names_with_metadata(table_ regclass, names regclass) IS 'idempotent.

deletes metadata mappings from names table.';

--