Insert GUID value into Postgresql database table

[Tokbanov]

I’m facing a problem with insertion of GUID data into PostgreSQL database table column.
How to congifure “DB Insert” node in order to be able to insert GUID into a table with UUID type column?

[mlauber71]

@Tokbanov you might want to check out this thread and the solution

Errors writing KNIME string to PostgreSQL uuid field

A solution could be something like this. You upload the file with the UUID into a emporary table and then insert it into the target table [image] The CAST() command would convert it into a uuid [image]

Errors writing KNIME string to PostgreSQL uuid field

So it turns out this is much simpler than expected. The other forum article you sent me to @mlauber71 gave a suggestion that fixed it without needing anything further. It turns out that JDBC is explicitly casting the GUID as a string in the prepared statement it sends to Postgres. By setting the “stringtype” JDBC parameter to “unspecified” the prepared statement sends the parameter values through without strongly typing them, so Postgres then interprets the string based on its format…which loo…

This is a way to first use a temporary table first:

Example how to use H2 database with a uuid unique identifier – mlauber71