Insert into postgre db

General
1

Hi community,

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[255]
  • carrier int
    -toolid int
    -tsp timestamp

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?

image
image1636×545 37.6 KB

2

I have problems with the same
I activate the flow but I do not receive an agglome response from the node.
any news about this ??
did you manage to solve it?

edit: i founded this and it works for me @open-kappa/node-red-contrib-mydb

3

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