javascript - How do I properly insert multiple rows into PG with node-postgres?

Question

A single row can be inserted like this:

client.query("insert into tableName (name, email) values ($1, $2) ", ['john', '[email protected]'], callBack)

This approach automatically comments out any special characters.

How do i insert multiple rows at once?

I need to implement this:

"insert into tableName (name, email) values ('john', '[email protected]'), ('jane', '[email protected]')"

I can just use js string operators to compile such rows manually, but then i need to add special characters escape somehow.

Answer 1

Use pg-format like below.

var format = require('pg-format');

var values = [
  [7, 'john22', '[email protected]', '9999999922'], 
  [6, 'testvk', '[email protected]', '88888888888']
];
client.query(format('INSERT INTO users (id, name, email, phone) VALUES %L', values),[], (err, result)=>{
  console.log(err);
  console.log(result);
});