-- Name: col_comment(col_ref); Type: FUNCTION; Schema: util; Owner: -

--

CREATE FUNCTION col_comment(col col_ref) RETURNS text

    LANGUAGE plpgsql STABLE STRICT

    AS $$

DECLARE

	comment text;

BEGIN

	SELECT description

	FROM pg_attribute

	LEFT JOIN pg_description ON objoid = attrelid

		AND classoid = 'pg_class'::regclass AND objsubid = attnum

	WHERE attrelid = col.table_ AND attname = col.name

	INTO STRICT comment

	;

	RETURN comment;

EXCEPTION

	WHEN no_data_found THEN PERFORM util.raise_undefined_column(col);

END;

$$;

--