html - 从 web html 上显示的 postgreSQL 数据库获取数据节点 js 时出错

Question

我从 postgreSQL 数据库中获取数据时发生 TypeError 我哪里有错误，我需要帮助！

const { ENGINE_METHOD_ALL } = require('constants');
var express = require('express'),
    path = require('path'),
    bodyParser = require('body-parser'),
    cons = require('consolidate'),
    dust = require('dustjs-helpers'),
    pg = require('pg'),
    app = express();

var connect = "postgres://postgres:admin@localhost/db1";

app.engine('dust', cons.dust);

app.set('view engine', 'dust');
app.set('views', __dirname + '/views');


app.use(express.static(path.join(__dirname, 'public')));

app.use(bodyParser.json());
app.use(bodyParser.urlencoded({ extended: false }));

    
app.get('/', function(req, res){
    pg.connect(connect, function(err, client, done) {
        if(err){
            return console.error('error fetching client from pool Data', err);
        }
        client.query('SELECT * FROM tbl_employee', function(err, result){
            if(err){
                return console.error('error query', err);
            }
            res.render('index', {tbl_employee: result.rows});
            done();
        });
    });
});

app.listen(3000, function(){
    console.log('server Started on port 3000');
});

出现错误警告。在此处输入图像描述

标签： htmlnode.jspostgresqldust.js