--

CREATE FUNCTION col_global_names(type regtype, OUT name text, OUT global_name text) RETURNS SETOF record

    AS $$

DECLARE

    prefix text := functions.name(type)||'.';

--

CREATE FUNCTION col_names(type regtype) RETURNS SETOF text

    AS $_$

BEGIN

    RETURN QUERY EXECUTE $$SELECT skeys(hstore(NULL::$$||type||$$))$$;

--

CREATE FUNCTION ensure_prefix(prefix text, str text) RETURNS text

    AS $_$

SELECT (CASE WHEN functions.has_prefix($1, $2) THEN $2 ELSE $1||$2 END)

$_$;

--

CREATE FUNCTION name(type regtype) RETURNS text

    AS $_$

SELECT typname::text FROM pg_type WHERE oid = $1

$_$;