Prodigy7kX
11/23/2021, 3:07 PM-- inserts a row into public.users
create function public.handle_new_user() returns trigger language plpgsql security definer
set
search_path = public as $$
begin
insert into public.profiles (user_id, first_name, last_name)
values (
new.id,
new.raw_user_meta_data->>'first_name',
new.raw_user_meta_data->>'last_name'
);
return new;
end;
$$;
-- 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_new_user();
jon.m
11/25/2021, 12:47 AMProdigy7kX
11/25/2021, 12:56 AMProdigy7kX
11/25/2021, 12:56 AMProdigy7kX
11/25/2021, 12:57 AM