Bulk inserts with epgsqli:equery/3?

[stra...@gmail.com]

Is there a way to do bulk inserts with epgsqli:equery/3? I'd like to insert sets of records into a single table in the database. Looking at the readme I see it's possible to do batch execution of statements. I want to execute one statement with multiple sets of parameters. Is this possible? The query I want to execute looks something like this:

INSERT INTO table (col1, col2)
VALUES
(row, 1),
(row, 2);

I know I can do this with epgsql:squery/2, so if this isn't possible it won't be problematic. I'm just curious if this is supported.

Thank you,

Trevor

[Sergey Prokhorov]

You may be interested in execute_batch https://github.com/epgsql/epgsql#batch-execution and prepared_query https://github.com/epgsql/epgsql#prepared-query

equery is not very eficient for batch/bulk loading.

пятница, 24 июня 2016 г., 19:35:47 UTC+3 пользователь stra...@gmail.com написал:

[led...@gmail.com]

epgsql:equery(Db,

"INSERT INTO table
(col1, col2)

SELECT row, UNNEST($1::INTEGER[])",
[[1,2]]).