© 2026 Hedgehog Software, LLC

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

Insert 3 rows at once

How to insert 3 rows at once via a trigger
using the values 3 times does not work
begin
  insert into public.reactioncount(parent_id, reaction_value)
  values(new.id, 'share');
  values(new.id, 'comment');
  values(new.id, 'like');
  return new;
end;
begin
  insert into public.reactioncount(parent_id, reaction_value)
  values(new.id, 'share');
  values(new.id, 'comment');
  values(new.id, 'like');
  return new;
end;
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

Insert data in several related tables at once
SupabaseSSupabase / help-and-questions
4y ago
Insert rows with user id (uuid)
SupabaseSSupabase / help-and-questions
4y ago
Acceptable method to insert multiple rows
SupabaseSSupabase / help-and-questions
4y ago
Number of requests at once
SupabaseSSupabase / help-and-questions
4y ago