NinjaNuur
04/18/2022, 1:11 PMdrop 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();
Function
create or replace function public.handle_new_user()
returns trigger
language plpgsql
security definer set search_path = public
as
$$
begin
if new.phone is null then
insert into public.company_user (id, email, first_name, last_name)
values (new.id, new.email, new.raw_user_meta_data ->> 'first_name', new.raw_user_meta_data ->> 'last_name');
return new;
else
insert into public.personal_user (id, phone)
values (new.id, new.phone);
return new;
end if;
end;
$$;
Any help would be appreciatedNeedle
04/18/2022, 1:11 PM/title
command!
We have solved your problem?
Click the button below to archive it.garyaustin
04/18/2022, 1:18 PMNeedle
04/18/2022, 1:18 PMNinjaNuur
04/18/2022, 1:23 PMgaryaustin
04/18/2022, 1:27 PMNinjaNuur
04/18/2022, 1:29 PMgaryaustin
04/18/2022, 1:32 PMNinjaNuur
04/18/2022, 1:36 PMNinjaNuur
04/18/2022, 1:36 PMgaryaustin
04/18/2022, 1:38 PMNinjaNuur
04/18/2022, 1:42 PMgaryaustin
04/18/2022, 2:21 PMgaryaustin
04/18/2022, 2:25 PMgaryaustin
04/18/2022, 2:33 PMNinjaNuur
04/18/2022, 4:06 PMNinjaNuur
04/18/2022, 4:06 PM