pg.query
Exposes the pg library for connecting to a PostgreSQL database.
Parameters
| Parameter | Description |
|---|---|
| connection: string | object | Connection configuration |
| query: string | SQL query |
| params?: any[] | Parameters of the query as an array (Optional) |
For more information, see the node-postgres documentation .
Returns
Promise that is resolved with the result of the query.
Examples
Insert a row into the 'test_orders' table
module.exports = async function(payload, actions, context) {
const result = await actions.pg.query(
process.env.DATABASE_URL,
'insert into test_orders (total) values ($1)',
[ payload.total_price ]
);
console.log('Query result: ', result);
}