Insert many rows in one statement.
Section: Insert, Update, Delete, and Merge
Insert multiple rows
sql
sql
INSERT INTO public.users (email)
VALUES ('a@example.com'), ('b@example.com'), ('c@example.com');Explanation
See summary for usage details.
Learn the surrounding workflow
Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.
Related commands
Same sheet · prioritizing Insert, Update, Delete, and Merge
Insert with RETURNING
Insert rows and immediately return generated values.
Upsert with ON CONFLICT
Handle unique conflicts by updating instead of failing.
Update from another table
Update rows using another table in the same statement.