PostgreSQL integration All Versions

Examples

• 1

  Connect To PostgreSQL
  1

  Using PostgreSQLnpm module.
  
  install dependency from npm
  

  npm  install pg --save
  

  Now you have to create a PostgreSQL connection, which you can later query.

  Assume you Database_Name = students, Host = localhost and DB_User= postgres

  var pg = require("pg")
  var connectionString = "pg://postgres:postgres@localhost:5432/students";
  var client = new pg.Client(connectionString);
  client.connect();
  

  created Nov 2 '16 at 6:39

  
  discuss
• 1

  Query with Connection Object
  1

  If you want to use connection object for query database you can use this sample code.

  var queryString = "SELECT name, age FROM students " ;
  var query = client.query(queryString);
  
  query.on("row", (row, result)=> {
  result.addRow(row);
  });
  
  query.on("end", function (result) {
  //LOGIC
  });
  

  created Nov 2 '16 at 9:48

  
  discuss