How to write to postgres column type text or varchar(255)

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?

Best,
Antje

Hi @niederle

have you tried mapping the text to e.g. nvarchar? Did that work?
Maybe that forum post helps:

Best,
Alice

1 Like

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.