Postgres 错误：语法错误位于或接近 ","

Question

我试图从代码中找到错误，但我不知道我错了什么。有人能看到上面的错误吗？

const {Client} = require('pg');
const client = new Client({
user: 'me',
host: 'localhost',
database: 'printer',
password: '1234',
port: 5432,
});
client.connect(function(err){
if (err) throw err
console.log("Connected Successfuly");
console.log("****if you want to stop this service, press Ctrl + C****");
var datain ='{"filename" : "filetest01.pdf","printer" : "Microsoft Print to PDF","address" : "C:\Users\parun\Desktop\printer\printerserver\photo","date" : "2020-11-23T17:00:00.000Z","status" : 1}';
var sql = 'INSERT INTO print(filename, printer, address, date, status) VALUES(?, ?, ?, ?, ?)';
client.query(sql, [datain.filename, datain.printer, datain.address, datain.date, datain.status],(err, result) => {
if (err)
throw err;
console.table(result.rows);
});
});

Answer 1

更改您的sql

var sql = 'INSERT INTO print(filename, printer, address, date, status) VALUES($1, $2, $3, $4, $5)';