Insert one row into a table.
Section: Insert, Update, Delete, and Merge
Insert row
sql
sql
INSERT INTO public.users (email) VALUES ('a@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.
Merge source data
Synchronize target data from a source relation with a single statement.