Update PostgreSQL Database With Node.js

I am trying to update a PostgreSQL table so for that I'm creating two arrays: var name_ = []; var id_ = []; Then I create a forEach loop where MyRow is a query that contains diff

Solution 1:

I'm not sure the error is related, but where is shema mentioned? Also use backticks, oneLine and const on template strings.

const updateAccount = oneLine`
   UPDATE myTable
   SET myRow = $1
   WHERE shema.id = $2  -- where is `shema` defined?
`;

Solution 2:

My guess is that you should enclose your values in single quotes.

var updateAccount = "UPDATE myTable SET myRow = '$1' "+
"where shema.id = '$2'"

In your example, your values are interpreted as column names, so PostgreSQL asks you to specify a table containing these.