I know about parameterized query, but since I have to programmatically construct the where condition, taking count of the parameters and building the parameters array is a task much more complex than simply calling an escape function when required. So:
is there a parameters escape function in node-postgres?
Yes, since this PR there are client.escapeIdentifier
and client.escapeLiteral
(sadly still undocumented), and since PR2954 (released with v8.11.0) they are exported and documented as pg.escapeIdentifier
and pg.escapeLiteral
.
However, it is not recommended to use them when you can use parameterised queries, and for dynamic WHERE
condition you can easily construct a query object with text
and values
on the fly.