Supabase Creating User Profile

Ask us anything
1

Hey everyone,

I’m testing a supabase x weweb integration.

When a user signs up, I want to create a corresponding profile for them in a separate (public) table. I’m running into two issues, first it seems like the user object isn’t being returned. That’s preventing me from creating the profile with the same uuid as the auth table.

Any advice getting past this? Seems really simple but I haven’t found a solution.

2

Best advice is to do this on supabase side.
If I remember correctly they have a template or an example of exactly this usecase.
This is what i have i my personal project

You need to create a function handle_new_user (Database > Functions)
This is what mine is looking like

begin
  insert into public.profiles (id)
  values (new.id);
  return new;
end;

Then you can use this function on a trigger

image
image1738×567 47.5 KB

1 Like
3

That’s exactly what I do.
Trigger after insert into auth.users > execute function
Be careful when setting all this, you have to dive into the advanced settings to allow your function to do it’s business. Security Definer is the option you should look for.

Have a nice day.

Matth-