I'm trying to add rows to

profiles

table when new users are added, including metadata like

email address

,

name

,

website

, all through the initial sign up function. So creating a new user like this:

javascript
      const { data, error } = await supabase.auth.signIn(
        { email: localStorage.getItem('email') },
        {
          data: {
            full_name: formData.get('full_name'),
            introduction: formData.get('introduction'),
            website_url: formData.get('website_url'),
            linkedin_url: formData.get('linkedin_url'),
            twitter_handle: formData.get('twitter_handle'),
            contact_method: formData.get('contact_method')
        }
      })

And handling it like this:

sql
create function public.handle_new_profile()
returns trigger as $$
begin
    insert into public.profiles (user_id, user_email, full_name, introduction, website_url, linkedin_url, twitter_handle, contact_method )
    values (new.id, new.email, new.raw_user_meta_data->>'full_name', new.raw_user_meta_data->>'introduction', new.raw_user_meta_data->>'website_url', new.raw_user_meta_data->>'linkedin_url', new.raw_user_meta_data->>'twitter_handle', new.raw_user_meta_data->>'contact_method');
    return new;
end;
$$ language plpgsql security definer;

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

Currently, new rows in

profiles

are created when the function is called — but they only contain the

user_id

and

user_email

fields, none of the other data. I feel like this might be some syntax error in the

public.handle_new_profile()

function, not receiving the user metadata or int it the right way. Can anybody suggest a troubleshoot/fix?

you're using magic links right? the signIn method doesn't have a data property in options so I think you can't add metadata when you sign in via magic links

Hey YelloJello, thanks so much for following up on this. Indeed, using

select * from auth.users

, I'm not seeing anything in the raw_user_meta_data column.

Ah I should have noticed that there was no data property in the second param to signIn

❤️ this is awesome! This is just what I was looking for. There was not documentation about this. At first I was trying

user_meta_data

but the correct name is

raw_user_meta_data

!!!!