如何使pg-promise将行作为数组返回？ [英] How to make pg-promise return rows as arrays?

问题描述

如何使 pg-promise 从查询中返回行数组，

How can we make pg-promise return an array of rows from a query, as opposed to array of row objects?

推荐答案

pg-promise 支持预处理语句和参数化查询，与 node-postgres 中的内容完全相同。其中一个参数- rowMode 可以设置为 array 使驱动程序将行作为数组返回。

pg-promise supports advanced parameters for Prepared Statements and Parameterized Queries, exactly as they are in node-postgres. One such parameter - rowMode, can be set to array to make the driver return rows as arrays.

// Prepared Statement:
await db.query({
    name: 'my-prep-statement',
    text: 'select ...', // a query or a QueryFile object (see PreparedStatement)
    values: [],
    rowMode: 'array'
});

// Parameterized Query:
await db.query({
    text: 'select ...', // a query or a QueryFile object (see ParameterizedQuery)
    values: [],
    rowMode: 'array'
});

另请参见将它们包装起来的类型： PreparedStatement 和参数化查询。

See also types that wrap them: PreparedStatement and ParameterizedQuery.

下面的代码与上面的代码等效，但是提供了更好的性能+可重用性+设置值的灵活性

The code below is equivalent to the one above, but offers better performance + re-usability + flexibility of setting values separately.

const ps = new pgp.PreparedStatement({
    name: 'my-prep-statement',
    text: 'select ...', // a query or a QueryFile object (see PreparedStatement)
    values: [], // alternatively, can be set when calling a query method
    rowMode: 'array'
});

await db.query(ps);

const pq = new pgp.ParameterizedQuery({
    text: 'select ...', // a query or a QueryFile object (see ParameterizedQuery)
    values: [], // alternatively, can be set when calling a query method
    rowMode: 'array'
});

await db.query(pq);

这篇关于如何使pg-promise将行作为数组返回？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！