© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•4y ago•
15 replies
devstojko

How to read user_metadata inside trigger function when new user is created?


begin
  insert into public.profiles(id, username)
  values(new.id, new.user_metadata.username);

  return new;
end;

begin
  insert into public.profiles(id, username)
  values(new.id, new.user_metadata.username);

  return new;
end;

This doesn't work. It says that user_metadata doesn't exist in new.

On signUp, I send data: { username }
Supabase banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

How to call api when new user is created
SupabaseSSupabase / help-and-questions
4y ago
error when inserting new user trigger
SupabaseSSupabase / help-and-questions
3y ago
Trigger to update user metadata when some userdata fields update
SupabaseSSupabase / help-and-questions
4y ago
how to detect when user has been created ?
SupabaseSSupabase / help-and-questions
4y ago