Thank you, I got it finally working. :)

const {
    Client
} = require('pg')

const client = new Client({
    user: 'USER',
    host: 'HOST',
    database: 'DB',
    password: 'PW',
    port: 5432,
})

async function beforeRender(req, res, done) {
    client.connect()
    const result = await client.query({
        text: 'SELECT column FROM table'
    })
    console.log(result.rowCount)
    Object.assign(req.data, {
        elements: result.rows
    })
    done();
}

Hello everybody,

I'm trying to adapt the given example to PostgreSQL, but my report is always empty. Can you tell me, what I'm doing wrong?

function beforeRender(req, res, done) {
    
const { Client } = require('pg')

const client = new Client({
  user: 'TEST',
  host: 'localhost',
  database: 'TEST',
  password: 'TEST',
  port: 5432,
})

client.connect()

client.query('SELECT lastname, firstname from TEST', (err, res) => {
  console.log(err, res)
  console.log(res.rowCount)
  client.end()
})
done();
}

It compiles and the DB connection is queried properly, I tried it with an UPDATE statement and could see the impact. My Problem is to save the results from a SELECT statement and reuse it in my template.