There is no parameter $1

[Khaled-Ch]

I am using node-postgress version 0.6.2 When I am running the following query

await pool.query( 'SELECT id, email from user where name = $1', ['jone'], );

I am getting this error

Error [ERR_UNHANDLED_ERROR]: Unhandled error. (Message { name: 'error', message: 'there is no parameter $1', severity: 'ERROR', code: '42P02', detail: undefined, hint: undefined, position: undefined, internalPosition: undefined, internalQuery: undefined, where: undefined, schema: undefined, table: undefined, column: undefined, dataType: undefined, constraint: undefined, file: '/home/ec2-user/padb/src/pg/src/backend/parser/parse_expr.c', line: '477', routine: 'transformExpr' })

However, If I run the same query with this format it works as expected

await pool.query( SELECT id, email from user where name = '${username}' );

NodeJs version is v14.17.3

[fuxingZhang]

This repository does not support Parameterized query.

You can use the best library(9.9k star +): https://github.com/brianc/node-postgres

docs: https://node-postgres.com/

const { Client } = require('pg')
const client = new Client()
await client.connect()
const res = await client.query('SELECT $1::text as message', ['Hello world!'])
console.log(res.rows[0].message) // Hello world!
await client.end()