I have an array of strings and I would like to insert it into a PostgreSQL array. I use query.pool() for the query. Here is my request but does not insert anything in the DB and I have no error message in the console.
Help me please ;))
const myArray = [ "first1.png", "second2.png", "third.png" ];
pool.query(
`INSERT INTO images(pic_name) VALUES($1)`,
[myArray],
(error, result) => {
if (error) {
res.status(400).json({ error });
}
res.status(200);
},
);