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
Create data in postgres General	15	472	8 October 2021
How to Insert Bool Values to PostgreSQL over Node Red General database	3	455	20 November 2022
Insert into postgre db General	2	264	30 April 2021
Insert into PostgreSQL database General	44	11044	26 August 2020
How insert msg.payload in Postgrestor node? General	3	944	5 May 2021

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