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?
it is hard to say without more information. How does configuration of node looks like? Does table already exists in database?
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.
glad you found a way. Anyways here is part of database documentation about DB Table Creator node:
Maybe it helps with other questions as well