Modifying raw_user_meta_data at registration

I've got a trigger function that fires after a user registers, I'm passing additional profile data through from my registration form into the raw_user_meta_data and the function pulls that out and inserts it into DB tables.

What I then want to do in my function is remove the keys from the meta_data that are now stored in the other tables. Is that possible?

I've got the following code which the AI assistant prompted me with but it doesn't appear to be working:

update auth.users
set
  raw_user_meta_data = raw_user_meta_data - 'key_to_remove_1' - 'key_to_remove_2'
where
  id = new.id;

update auth.users
set
  raw_user_meta_data = raw_user_meta_data - 'key_to_remove_1' - 'key_to_remove_2'
where
  id = new.id;

update auth.users
set
  raw_user_meta_data = raw_user_meta_data - 'key_to_remove_1' - 'key_to_remove_2'
where
  id = new.id;

update auth.users
set
  raw_user_meta_data = raw_user_meta_data - 'key_to_remove_1' - 'key_to_remove_2'
where
  id = new.id;

Modifying raw_user_meta_data at registration

Similar Threads

Similar Threads

Similar Threads