creating a new user in signup function
so I remember that I did this somehow, I think it was automatic when I set up my project, however not sure what happened and now that function along with the trigger is no longer there. So I'm trying to add it from the start and can't figure out what I am doing wrong. This is my table of profiles I want to add my new users. And this is the function I'm trying to use for the trigger:
begin
insert into public.profiles (id, username, avatar_url)
values (new.id, new.raw_user_meta_data->>'username', new.raw_user_meta_data->>'avatar_url');
return new;
end;
