Hi,
I have a postgres database where we add data with KNIME. As there was no need for it the past 4 years, I loaded some pretty old workflows and tried to replace the legacy database nodes. But when it comes to writing to that database I realized that with the legacy nodes I could type in the database column type for each KNIME table type.
Now, there is a mapping interface which by default maps String(KNIME type) to VARCHAR(database type).
But some of my database columns are ‘varchar(255)’ and others are ‘text’. How would I have to handle that? There is no mapping to ‘text’ available…
Can anybody help?