-- Name: set_col_names(regclass, regclass); Type: FUNCTION; Schema: functions; Owner: -

--

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

    LANGUAGE plpgsql STRICT

    AS $_$

DECLARE

    old text[] = ARRAY(SELECT functions.col_names(table_));

    new text[] = ARRAY(SELECT functions.map_values(names));

BEGIN

    old = old[1:array_length(new, 1)]; -- truncate to same length

    PERFORM functions.rename_if_exists($$ALTER TABLE $$||$1||$$ RENAME $$

        ||quote_ident(key)||$$ TO $$||quote_ident(value))

    FROM each(hstore(old, new));

END;

$_$;

--

-- Name: FUNCTION set_col_names(table_ regclass, names regclass); Type: COMMENT; Schema: functions; Owner: -

--

COMMENT ON FUNCTION set_col_names(table_ regclass, names regclass) IS 'idempotent';

--