4 ms·
The simplest way to perform a batch insert is by using an INSERT statement with many rows in the VALUES clause. E.g., INSERT INTO table (columns...) VA
by cpburns2009 9y ago
The simplest way to perform a batch insert is by using an INSERT statement with many rows in the VALUES clause. E.g.,
INSERT INTO table (columns...)
VALUES
(row 1...),
(row 2...),
...
An alternative and potentially faster method is using the COPY FROM statement.