var express = require('express');
var pg = require('pg');
var app = express();
var connectionString = "postgres://...";
app.get('/',function (req,res,next) {
pg.connect(connectionString,function (err,client,done) {
if (err) {
console.log("not able to get connection " + err);
res.status(400).send(err);
}
client.query('SELECT * FROM employee WHERE empid=$1',[1],result) {
done(); // closing the connection;
if (err) {
console.log(err);
res.status(400).send(err);
}
res.status(200).send(result.rows);
});
});
});
app.listen(3000,function () {
console.log('Server is running.. on Port 3000');
});
这是我的nodejs文件,而connectionString是连接heroku和postgreSQL的数据库信息。
但是当我运行这个时,我只会得到
client.query('SELECT * FROM employee WHERE empid=$1',result) {
^
TypeError: Cannot read property 'query' of null
我该如何解决?