I am using node red 1.2.6 and a POSTGRESQL13 db and want to insert values into the db with the node "postgrestor".
My query within the node:
INSERT INTO tightnesstest (diffpressure, carrier, toolid, tsp) VALUES($1, $2, $3, $4);
Table tightnesstest has 4 columns:
- diffpressure varchar
- carrier int
With the command line I can write an read the table with e.g. the query "INSERT INTO tightnesstest (diffpressure, carrier, toolid, tsp) VALUES(22,12,12345,'2021-02-16');", but with the node "postgrestor" I can not and I do not receive any error message.
Has anybody an idea why?