Knex / Jade：无法读取未定义的属性“ length”

尝试切换出Mongo并放入Postgres（换句话说，类似的代码在Mongo中可以正常工作）。获取Cannot read property 'length' of undefined以下代码。我敢肯定这很简单，但是我是整个堆栈的新手，所以很难将它们绑在一起。在knex上没有很多示例，因此即使文档相当不错，我也很难找到要复制的示例。

我显然是在提取正确的数据，但仍然坚持如何使玉显示出来。

堆栈：Node / Express / Knex / Postgres / Jade

users.js

router.get('/', function(req, res, next) {
  db.select().from('users').limit(1)
    .then(function(users) {
        console.dir(users)})
    .then(function(users) {
        res.render('users', {users: users})})
    .catch(function(error) {
        console.error(error)
  })
});

users.jade

extends layout

block content
  h1 Users
  ul
    for user in users
      p 
        input(type="text", name="name", value="#{user.name}")
        input(type="text", name="admin", value="#{user.admin}")
        input(type="text", name="smsNumber", value="#{user.smsNumber}")

安慰

[ { uid: 1,
    name: 'Don',
    admin: 'true',
    smsNumber: '4077023951',
    created_at: null,
    updated_at: null } ]

浏览器位于localhost：3000 / users

C:\Users\dvande03\Personal\dailychallenge\views\users.jade:6 4| h1 Users 5| ul > 6| for user in users 7| p 8| input(type="text", name="name", value="#{user.name}") 9| input(type="text", name="admin", value="#{user.admin}") Cannot read property 'length' of undefined

TypeError: C:\Users\dvande03\Personal\dailychallenge\views\users.jade:6
    4|   h1 Users
    5|   ul
  > 6|     for user in users
    7|       p 
    8|         input(type="text", name="name", value="#{user.name}")
    9|         input(type="text", name="admin", value="#{user.admin}")

Cannot read property 'length' of undefined
    at eval (eval at <anonymous> (C:\Users\dvande03\Personal\dailychallenge\node_modules\jade\lib\index.js:218:8), <anonymous>:51:31)
    at eval (eval at <anonymous> (C:\Users\dvande03\Personal\dailychallenge\node_modules\jade\lib\index.js:218:8), <anonymous>:106:4)
    at eval (eval at <anonymous> (C:\Users\dvande03\Personal\dailychallenge\node_modules\jade\lib\index.js:218:8), <anonymous>:119:22)
    at res (C:\Users\dvande03\Personal\dailychallenge\node_modules\jade\lib\index.js:219:38)
    at Object.exports.renderFile (C:\Users\dvande03\Personal\dailychallenge\node_modules\jade\lib\index.js:380:38)
    at Object.exports.renderFile (C:\Users\dvande03\Personal\dailychallenge\node_modules\jade\lib\index.js:370:21)
    at View.exports.__express [as engine] (C:\Users\dvande03\Personal\dailychallenge\node_modules\jade\lib\index.js:417:11)
    at View.render (C:\Users\dvande03\Personal\dailychallenge\node_modules\express\lib\view.js:126:8)
    at tryRender (C:\Users\dvande03\Personal\dailychallenge\node_modules\express\lib\application.js:639:10)
    at EventEmitter.render (C:\Users\dvande03\Personal\dailychallenge\node_modules\express\lib\application.js:591:3)
    at ServerResponse.render (C:\Users\dvande03\Personal\dailychallenge\node_modules\express\lib\response.js:961:7)
    at C:\Users\dvande03\Personal\dailychallenge\routes\users.js:11:13
    at tryCatcher (C:\Users\dvande03\Personal\dailychallenge\node_modules\bluebird\js\main\util.js:24:31)
    at Promise._settlePromiseFromHandler (C:\Users\dvande03\Personal\dailychallenge\node_modules\bluebird\js\main\promise.js:454:31)
    at Promise._settlePromiseAt (C:\Users\dvande03\Personal\dailychallenge\node_modules\bluebird\js\main\promise.js:530:18)
    at Promise._settlePromises (C:\Users\dvande03\Personal\dailychallenge\node_modules\bluebird\js\main\promise.js:646:14)