Essential Books

Inserting multiple rows

suggest change

You can insert multiple rows in the database at the same time: 

INSERT INTO person (name, age) VALUES 
  ('john doe', 25),
  ('jane doe', 20);
Found a mistake? Have a question or improvement idea? Let me know.

Feedback about page:

Feedback:
Optional: your email if you want me to get back to you:

INSERT:
* Insert data using COPY
* Inserting multiple rows
* INSERT data and RETURING values
* Basic INSERT
* Insert from select
* SELECT data into file.
* UPSERT - INSERT ... ON CONFLICT DO UPDATE...
Table Of Contents