How to store image into postgreSQL

[MartinDDDD]

Well I think it depends on what you want to achieve.

What I think won’t work is storing a plain image as jpg or png.

You definitely can store a link (although by the looks of it that’s not what you seem to be after) or probably an image converted to binary format.

There’s PNG to binary node:

PNGs to Binary Objects

And for non png you could use ImgPlus to png

ImgPlus to PNG Images

To then get int into the DB there’s an example from @takbb here:

Inserting Binary Data into SQL Database Using KNIME

Hi @SnigdhaBiswas , I’ve put a demo workflow on the hub, using the H2 database as an example. This uploads some binary files from the workflow’s data folder, and then reads the binary data back from the database, for display in a KNIME table. [image] On the H2 database, I defined the column as BLOB datatype. create table IMAGES (ID numeric(5), IMAGE_BINARY blob) In the DB Insert node, I set the data type mapping for Binary object as follows: [image] It didn’t work if I set it mapping …

In general I think you have to set the column in your DB to type binary in the insert node.