-- Name: show_relations_like(text, text, character[]); Type: FUNCTION; Schema: util; Owner: -

--

CREATE FUNCTION show_relations_like(name_regexp text, schema_regexp text DEFAULT ''::text, types character[] DEFAULT ARRAY['r'::text, 'v'::text]) RETURNS SETOF regclass

    LANGUAGE sql STABLE

    AS $_$

SELECT oid FROM pg_class

WHERE relkind = ANY($3) AND relname ~ $1

AND util.schema_matches(util.schema(relnamespace), $2)

ORDER BY relname

$_$;

--