Create table in DB (DB Table creator ERROR)

KNIME Analytics Platform
1

Hi!
I have data that I get from webservice and going to put in table in DB (postgres). For this I use PostgreSQL Connector and then DB Table creator node (to create new table in DB). But in executing DB Table creator node I have an ERROR: "syntax error at or near "NOT".
Can anybody explain where I could made mistake?

2

Hello @Pavel_Msc,

it is hard to say without more information. How does configuration of node looks like? Does table already exists in database?

Br,
Ivan

1 Like
3

Ivan!
Thanks a lot for responsiveness!
This issue was solved. I create a table in DB. Not from KNIME. Now all is OK. There is one question with upload data in this table, but it is not about this topic.

1 Like
4

Hello @Pavel_Msc,

glad you found a way. Anyways here is part of database documentation about DB Table Creator node:
https://docs.knime.com/latest/db_extension_guide/index.html#db_creator

Maybe it helps with other questions as well :wink:

Br,
Ivan

5

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