Create user trigger 500

create or replace function public.handle_new_user()
returns trigger as
$$
  begin
    insert into public."User" (id, email, userType)
    values (new.id, new.email, new.raw_user_meta_data->>'user_type');
    return new;
  end;
$$
language plpgsql security definer;

drop trigger if exists on_auth_user_created on auth.users; 
create trigger on_auth_user_created
  after insert on auth.users
  for each row
    execute procedure public.handle_new_user();

create or replace function public.handle_new_user()
returns trigger as
$$
  begin
    insert into public."User" (id, email, userType)
    values (new.id, new.email, new.raw_user_meta_data->>'user_type');
    return new;
  end;
$$
language plpgsql security definer;

drop trigger if exists on_auth_user_created on auth.users; 
create trigger on_auth_user_created
  after insert on auth.users
  for each row
    execute procedure public.handle_new_user();