Skip to content

Instantly share code, notes, and snippets.

@ftisiot

ftisiot/insert_multiple_rows.sql

Created January 26, 2022 09:08
Show Gist options
  • Save ftisiot/fc4024a42452fc9bc22c03224dd1de74 to your computer and use it in GitHub Desktop.
Save ftisiot/fc4024a42452fc9bc22c03224dd1de74 to your computer and use it in GitHub Desktop.
Download ZIP
PostgreSQL Insert multiple rows in one go
Raw
insert_multiple_rows.sql
CREATE TABLE students (student_id INT, student_name VARCHAR(200));
INSERT INTO students values (1, 'Francesco'), (2, 'Maria'), (3, 'Giuseppa');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment