I have a flow that received mqtt and save to postgres using re-postgres. Here's my flow. [ { "id": "03a53e00c9c78103", "type": "function", "z": "14ee6d7566a42e0e", "name": "function 3", "func": "var topic1 = msg.topic;\nvar payload1 = JSON.stringify(msg.p…

Marc123 2 March 2023 13:06 3

The postgres node expects sql to be in msg.query

Also, there are multiple postgres nodes in the palette manager, the only one I've found to work reliably is
"node-red-contrib-postgresql"

1 Like

Node Red to Postgres (closed - duplicate)

Topic		Replies	Views
Node-Red with MQTTsaving data to Postgres General	2	155	18 February 2023
Node-Red to PostgreSQL General database	8	125	30 April 2023
Node-Red to Posgresql General database , mqtt	3	135	1 May 2023
How do I write dynamic data to Postgres DB General database	4	284	13 November 2022
Node-red-contrib-postgrestor-next General database , mqtt	1	122	2 May 2023

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.

Node-Red save to Postgres

Related Topics