$ cat dump2.sql | grep -B 3 unacc
CREATE EXTENSION IF NOT EXISTS pgcrypto WITH SCHEMA public;
COMMENT ON EXTENSION pgcrypto IS 'cryptographic functions';

CREATE EXTENSION IF NOT EXISTS unaccent WITH SCHEMA public;
COMMENT ON EXTENSION unaccent IS 'text search dictionary that removes accents';
--
CREATE FUNCTION public.str_norm(text) RETURNS text
    LANGUAGE sql IMMUTABLE
    AS $_$
  SELECT unaccent(coalesce($1, 'My'));
--
CREATE FUNCTION public.str_norm(text) RETURNS text
    LANGUAGE sql IMMUTABLE
    AS $_$
  SELECT unaccent(coalesce($1, ''));
--
CREATE FUNCTION public.str_norm_iguides(text) RETURNS text
    LANGUAGE sql IMMUTABLE
    AS $_$
  SELECT unaccent(coalesce($1, ''));
--

CREATE MATERIALIZED VIEW public.emails_text_search AS
 SELECT emails.id AS email_id,
    (((setweight(to_tsvector('simple'::regconfig, public.unaccent(emails.subject)), 'A'::"char") || setweight(to_tsvector('simple'::regconfig, public.unaccent(array_to_string(COALESCE(emails.to_list, '{}'::text[]), ' '::text))), 'B'::"char")) || setweight(to_tsvector('simple'::regconfig, public.unaccent(array_to_string(COALESCE(emails.cc_list, '{}'::text[]), ' '::text))), 'B'::"char")) || setweight(to_tsvector('simple'::regconfig, public.unaccent(array_to_string(COALESCE(emails.bcc_list, '{}'::text[]), ' '::text))), 'B'::"char")) AS text