sql multiple insert postgres
snippet in sql

postgresql insert multiple rows

user2141


        
            
        
     INSERT INTO table_name (column_list)
VALUES
    (value_list_1),
    (value_list_2),
    ...
    (value_list_n);

sql multiple insert postgres

user3957

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