PostgreSQLで複数行を一括挿入(INSERT)
postgresql
1行ずつ実行する場合
insert into table_name (column1, column2, column3) values (data1, data2, data3);
insert into table_name (column1, column2, column3) values (data1, data2, data3);
insert into table_name (column1, column2, column3) values (data1, data2, data3);複数行一括で実行する場合
insert into table_name (column1, column2, column3 )values
(data1, data2, data3),
(data1, data2, data3),
(data1, data2, data3);
