Trigger Function

I currently have this trigger and function to add a new row to my public users table whenever a new user signs up.
How do I also trigger a function that adds a row in the

folder

folder

table with the name set to 'default' and the userId set to the new user that was just created?
My

folder

folder

table has the following columns: id, name, userId

Thank you!

create or replace function public.handle_new_user() 
returns trigger as $$
begin
  insert into public.users (id, email)
  values (new.id, new.email);
  return new;
end;
$$ language plpgsql security definer;

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()

create or replace function public.handle_new_user() 
returns trigger as $$
begin
  insert into public.users (id, email)
  values (new.id, new.email);
  return new;
end;
$$ language plpgsql security definer;

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()

Supabase•4y ago•

15 replies

Zeph

Trigger Function

I currently have this trigger and function to add a new row to my public users table whenever a new user signs up.
How do I also trigger a function that adds a row in the

folder

folder

table with the name set to 'default' and the userId set to the new user that was just created?
My

folder

folder

table has the following columns: id, name, userId

Thank you!

create or replace function public.handle_new_user() 
returns trigger as $$
begin
  insert into public.users (id, email)
  values (new.id, new.email);
  return new;
end;
$$ language plpgsql security definer;

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()

create or replace function public.handle_new_user() 
returns trigger as $$
begin
  insert into public.users (id, email)
  values (new.id, new.email);
  return new;
end;
$$ language plpgsql security definer;

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()

Trigger Function

Similar Threads

Trigger Function

Similar Threads

Similar Threads

Similar Threads