18 lines
510 B
PL/PgSQL
18 lines
510 B
PL/PgSQL
-- 9. Trigger to push new auth users into public.users
|
|
create or replace function public.handle_new_user()
|
|
returns trigger
|
|
language plpgsql
|
|
security definer set search_path = ''
|
|
as $$
|
|
begin
|
|
insert into public.users (id, email, name)
|
|
values (new.id, new.email, new.raw_user_meta_data->>'full_name');
|
|
return new;
|
|
end;
|
|
$$;
|
|
|
|
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();
|