postgres bulk insert multiple rows code example
Example: sql multiple insert postgres
INSERT INTO User (name, surname, "roomId") // roomId is with quetes("") because it is case sensitive in this example
VALUES
('Joe', 'Travolta', 1),
('Jim', 'Carrey', 2),
('Shakira', 'whenever', 3); // remember about semicolon(;) at the end