how to postgresql two insert select query 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