I'm a beginner with Node-Red, I try to insert data to PostgreSQL but the data is still not inserted on the table. I don't have any idea what the reason is? Perhaps someone could help me to solve it? thank you I attached a screenshot of my work... [ask3] [ask1]

Yes it seems to work without problems: [ { "id": "23fe0d38e71e8b24", "type": "postgrestor", "z": "ee21e3b499ee5ae7", "name": "insert", "query": "INSERT INTO temperature (speed1,speed2,speed3) VALUES ('{{msg.speed1}}','{{msg.speed2}}','{{msg.speed3}}');\n\…

rko 8 October 2021 04:59 2

Putting the query into msg.topic does not seem right to me. Can you confirm that this is correct?

Also you might want to use a different node for PostgreSQL integration.

Topic		Replies	Views
Insert into PostgreSQL database General	44	11567	26 August 2020
Create data in postgres General	15	508	8 October 2021
Node-Red to Posgresql General database , mqtt	3	183	1 May 2023
Node-Red save to Postgres General database , mqtt	5	328	2 May 2023
Msg.payload data writing to Postgres General	16	3224	25 April 2020

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

How to Insert Value to PostgreSQL over Node Red

Related topics