Does anyone now how you can insert the msg.payload value into a Postgresql database using the Postgrestor node?
Defining msg.payload doesn't work becuase this is not SQL language.
Does anyone now how you can insert the msg.payload value into a Postgresql database using the Postgrestor node?
Defining msg.payload doesn't work becuase this is not SQL language.
According to the help info
VALUES ('{{msg.payload}}', NOW(), '1');
It is that easy. Thank you very much!
This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.