Guest User

Untitled

a guest
Apr 25th, 2018
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.58 KB | None | 0 0
  1. var pg = require("pg");
  2. var connectionString = {
  3. user: 'user',
  4. host: 'host',
  5. database: 'db',
  6. password: 'pass',
  7. port: 5432, };
  8. var pool = new pg.Pool(connectionString);
  9. pool.connect(function(err, client, done) {
  10. const query = client.query(new pg.Query("SELECT * from products")) query.on('row', (row) => {
  11. console.log(row);
  12. })
  13. query.on('end', (res) => {
  14. // pool shutdown
  15. console.log("ending");
  16. pool.end()
  17. })
  18. query.on('error', (res) => {
  19. console.log(res);
  20. })
  21. done() })
  22.  
  23. SELECT array_to_string(array( SELECT row_to_json(products.*) FROM products),', ') as jsonData;
Add Comment
Please, Sign In to add comment