Peanut
08/22/2021, 6:18 AMsilentworks
08/22/2021, 1:04 PMsql
-- inserts a row into public.users
create function public.handle_new_user()
returns trigger as $$
begin
insert into public.users (id)
values (new.id);
return new;
end;
$$ language plpgsql security definer;
and a trigger for the function like:
sql
-- 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();
Peanut
08/24/2021, 6:42 AMPeanut
08/24/2021, 6:43 AMPeanut
08/24/2021, 6:43 AM