node-red-contrib-postgrestor 0.0.5-RC01

Yet another Node-RED node to query PostgreSQL

npm install node-red-contrib-postgrestor

CircleCI NPM version dependencies Status devDependencies Status npm npm npm npm

node-red-contrib-postgrestor

Node-red-contrib-postgrestor :space_invader: is a Node-RED node allowing basic access to Postgres :elephant: database.

Node-red-contrib-postgrestor sets up a console to execute queries against the configured database.

msg.payload will contain the result object of the query. It has the following properties:

  • command: The sql command that was executed (e.g. "SELECT", "UPDATE", etc.)
  • rowCount: The number of rows affected by the SQL statement
  • oid: The oid returned
  • rows: An array of rows

Postgres implements a template engine allowing parameterized queries:

/* INTEGER id COLUMN */
SELECT * FROM table WHERE id = {{ msg.id }}

/* VARCHAR id COLUMN */
SELECT * FROM table WHERE id = '{{ msg.id }}'

Installation

Using the Node-RED Editor

From version 0.15 of Node-RED you can install node-red-contrib-postgrestor directly using the editor. To do this select Manage Palette from the menu (top right), and then select the install tab in the palette.

You can now search for node-red-contrib-postgrestor to install.

Installing npm packaged nodes

To install node-red-contrib-postgrestor npm-packaged node, you can also, either install it locally within your user data directory (by default, $HOME/.node-red):

cd $HOME/.node-red
npm i node-red-contrib-postgrestor

or globally alongside Node-RED:

npm i -g node-red-contrib-postgrestor

You will need to restart Node-RED for it to pick-up node-red-contrib-postgrestor.

NPM

Screen shots

Node Info

Version: 0.0.5-RC01
Updated 6 years, 11 months ago
License: Apache
Rating: 5.0 2

Categories

Actions

Rate:

Downloads

17 in the last week

Nodes

  • postgresDB
  • postgrestor

Keywords

  • node-red
  • postgresql
  • postgres

Maintainers