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

by

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);
});

More Related Contents:

  1. What is this JavaScript “require”?
  2. Multi-row insert with pg-promise
  3. Making a javascript string sql friendly
  4. What is the proper way to use the node.js postgresql module?
  5. php How to save post and save show to php file like this [closed]
  6. Is it an anti-pattern to use async/await inside of a new Promise() constructor?
  7. Understanding the Event Loop
  8. Difference between “module.exports” and “exports” in the CommonJs Module System
  9. How to use nodejs to open default browser and navigate to a specific URL
  10. Function to convert timestamp to human date in javascript [duplicate]
  11. Node.js tail-call optimization: possible or not?
  12. Basic Ajax send/receive with node.js
  13. Puppeteer page.evaluate querySelectorAll return empty objects
  14. Singleton pattern in nodejs – is it needed?
  15. Understanding code flow with yield/generators
  16. How to clone a javascript ES6 class instance
  17. Pattern for CoffeeScript modules [duplicate]
  18. Angular 2 – How to pass URL parameters?
  19. Sending message to a specific connected users using webSocket?
  20. ‘react-scripts’ is not recognized as an internal or external command
  21. Asynchronous constructor
  22. how does axios handle blob vs arraybuffer as responseType?
  23. How to structure nested Promises
  24. Accessing Express.js local variables in client side JavaScript
  25. Exporting Node module from promise result
  26. Limit concurrency of pending promises
  27. What is the difference between .js and .mjs files?
  28. Checking if a message was sent from a DM channel type not working
  29. Recursive Promises Not Returning
  30. How to structure a express.js application?

Leave a Comment