-- Name: mk_drop_from_create(text); Type: FUNCTION; Schema: util; Owner: -

--

CREATE FUNCTION mk_drop_from_create(create_cmd text) RETURNS text

    LANGUAGE sql IMMUTABLE

    AS $_$

SELECT (util.regexp_match($1,

'(?m)^CREATE(?: OR REPLACE)? ((?:)??[[:upper:]]+ .*?)(?: AS ?)?$'))[1]

	/* (?:)?? makes the surrounding () group non-greedy, so that (?: AS ?)?

	works properly (due to nonstandard Postgres regexp behavior:

	http://www.postgresql.org/docs/9.3/static/functions-matching.html#POSIX-MATCHING-RULES) */

$_$;

--