Y
Hacker News
new
|
ask
|
show
|
jobs
by
stonelazy
3312 days ago
I wonder what the author means by batch inserts ? How would it have been achieved ? Is it a procedure or something ?
1 comments
cpburns2009
3312 days 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.
link