Fork me on GitHub
#sql
<
2017-02-08
>
ilevd08:02:02

Does anyone know how to insert multiple rows via YESQL?

curtis.summers11:02:50

@ilevd A few options: 1) loop through your inserts in a transaction, 2) use clojure.java.jdbc's insert-multi!, 3) use HugSQL's (disclaimer: I'm the author) Tuple List parameter type: https://www.hugsql.org/#param-tuple-list

ilevd14:02:37

@curtis.summers I did with insert-multi!, HugSQL looks interesting, thanks