Errors writing KNIME string to PostgreSQL uuid field

[mlauber71]

@ettobias welcome to the KNIME forum

The solution might very well look something like this:

Insert JSON value into Postgresql database table

Hello Tokbanov, in order to write a KNIME JSON cell into a Postgres JSON column you need to do the following: In the PostgreSQL Connector node you need to add the speciy the JDBC Parameter stringtype=unspecified [image] and you need to add the following mapping JSON->String->Varchar to the Output Type Mapping tab [image] Once this is done you should be able to write JSON cells into JSON columns in the database. When you want to read the data back into KNIME you can use the DB Type…

Since KNIME might not have a data type uuid you would have to store it as a string and when insertig it into Postgres make sure it is recognized as uuid.

You might also upload the KNIME file into a temporary Postgres table and then convert it into uuid with somethink like:

CAST(<your_variable> AS uuid) AS <your_target_variable>

I might see if I can come up with an example how to do that