[Postgres] Event trigger on table created

event_trigger_on_table_create.sql

CREATE FUNCTION public.on_create_table_funct()
    RETURNS event_trigger
    LANGUAGE 'plpgsql'
    COST 100
    VOLATILE NOT LEAKPROOF SECURITY DEFINER
AS $BODY$

DECLARE
    sch text;
BEGIN
FOR sch IN SELECT nspname FROM pg_namespace WHERE nspname NOT LIKE 'pg%' AND nspname NOT LIKE 'information%' AND nspname = 'public'
    LOOP
    EXECUTE format($$ GRANT SELECT,INSERT,UPDATE,REFERENCES,TRIGGER ON ALL TABLES IN SCHEMA %I TO readonlybase $$, sch);
    END LOOP;
END;
$BODY$;

ALTER FUNCTION public.on_create_table_funct() OWNER TO postgres;

GRANT EXECUTE ON FUNCTION public.on_create_table_funct() TO postgres;
GRANT EXECUTE ON FUNCTION public.on_create_table_funct() TO PUBLIC;