Alternative notify_ddl_postgrest event trigger

notify_ddl_postgrest.sql

CREATE OR REPLACE FUNCTION public.notify_ddl_postgrest() 
RETURNS event_trigger 
AS $$ 
DECLARE
   obj RECORD;
BEGIN 
   FOR obj IN SELECT * FROM pg_event_trigger_ddl_commands()
   LOOP
      IF obj.object_type IN ('type','function','procedure')
      THEN
         NOTIFY ddl_command_end;
      END IF;
   END LOOP;
END; 
$$ LANGUAGE 'plpgsql';

CREATE EVENT TRIGGER ddl_postgrest ON ddl_command_end EXECUTE PROCEDURE public.notify_ddl_postgrest();