Hello KNIME Support Team!
I am facing a problem while writing a column existing in Josn format to a table in PostgreSQL.
I checked through several examples and found that I need to create the type of the column as JSON first with “DB Table Creator”. In the case of “DB Table Creator(deprecated)” node, I can create the column as json type as shown below.
However, in the regular “DB Table Creator” node, you cannot put the data in josn form because the Column type does not provide a json type.
Since we cannot use the deprecated node for security reasons, is there any way to select the json type option in the regular “DB Table Creator” node?