'how to update JSON string into blob column

I have a blob column with PSQL DB. When I try to update the column via Sequelize with raw query I get: "SequelizeDatabaseError: invalid input syntax for type bytea"

{
  replacements: {data: JSON.stringify(data), id: result.id},
  type: queryInterface.sequelize.QueryTypes.UPDATE,
});
node.jspostgresqlsequelize.js


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions