SQL

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

postgresql insert multiple rows

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

postgresql multiple insert with subquery

INSERT INTO table1 (col1, col2) 
SELECT col1, col2 
  FROM othertable