fun.sql

create or replace function update_profile () returns trigger security definer language plpgsql as $$
begin
  update public.profiles
  set email = new.email
  where id = new.id;
  return new;
end;
$$;

create trigger update_profile_trigger
after
update on auth.users for each row
execute function public.update_profile ();