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

--

CREATE FUNCTION to_global_col_names(table_ regclass) RETURNS void

    LANGUAGE plpgsql STRICT

    AS $_$

DECLARE

    row record;

BEGIN

    FOR row IN SELECT * FROM functions.col_global_names(table_::text::regtype)

    LOOP

        IF row.global_name != row.name THEN

            EXECUTE $$ALTER TABLE $$||table_||$$ RENAME $$

                ||quote_ident(row.name)||$$ TO $$||quote_ident(row.global_name);

        END IF;

    END LOOP;

END;

$_$;

--

-- Name: FUNCTION to_global_col_names(table_ regclass); Type: COMMENT; Schema: functions; Owner: -

--

COMMENT ON FUNCTION to_global_col_names(table_ regclass) IS 'idempotent';

--