postgresql - Postgresql in Node-red

Question

I use node-red to create an Api from a server. I want to read and send data via http. I use the browser-based programming method. I want to send data from a postgresql database. I installed the package node-red-contrib-postgres-multi. I don´t know how to put data into the database and how to read data from the database, because I cannot find examples.

Does anybody knows, how I can do that?

标签： postgresqlhttpserverclientnode-red

Answer 1

您可以使用postgrestor postgrestor 包，您可以直接在节点窗口中定义查询或数据修改语句。它还允许通过模板引擎进行参数化查询。

我遇到的问题是在同一流程中使用多个数据库实例，但如果您只需要一个数据库实例连接，它应该适合您。