-- inserts a row into either providers or team tables based on email address
create function public.handle_and_place_new_user()
returns trigger as $$
begin
if position('@arrowgtp.com' in new.email) > 0 then
insert into public.team (id, full_name, avatar_url, role)
values (new.id, new.raw_user_meta_data->>'full_name', new.raw_user_meta_data->>'avatar_url', 'team');
else
insert into public.providers (id, full_name, avatar_url)
values (new.id, new.raw_user_meta_data->>'full_name', new.raw_user_meta_data->>'avatar_url');
end if;
return new;
end;
$$ language plpgsql security definer;
-- trigger the function every time a user is created
create trigger on_auth_user_created
after insert on auth.users
for each row execute procedure public.handle_and_place_new_user()
-- inserts a row into either providers or team tables based on email address
create function public.handle_and_place_new_user()
returns trigger as $$
begin
if position('@arrowgtp.com' in new.email) > 0 then
insert into public.team (id, full_name, avatar_url, role)
values (new.id, new.raw_user_meta_data->>'full_name', new.raw_user_meta_data->>'avatar_url', 'team');
else
insert into public.providers (id, full_name, avatar_url)
values (new.id, new.raw_user_meta_data->>'full_name', new.raw_user_meta_data->>'avatar_url');
end if;
return new;
end;
$$ language plpgsql security definer;
-- trigger the function every time a user is created
create trigger on_auth_user_created
after insert on auth.users
for each row execute procedure public.handle_and_place_new_user()
