node-red-contrib-postgres-heroku

node-red-contrib-herokupg

Node-red-contrib-herokupg is a Node-RED node allowing basic access to Postgres 🐘 database.

This is a fork of the postgrestor that has been modified to use a Postgres URL as the connection details specifically the format used by the Heroku addon suplied in an environment varible.

Configuration

The herokupg_config node takes a single url with the details of the postgres server and database eg: postgres://user:password@hostname:port/database

This can be supplied in 3 ways, the default is an env parameter called DATABASE_URL which is the Heroku default, you can also specify any other env parameter or just enter it as a string.

Queries

The HerokuPG node Pass them as a parameter array *params of the msg object.

The node sets up a console to execute queries against the configured database.

It also suports mustache templates within queries queries:

SELECT * FROM table WHERE name = '{{ msg.name }}'

SELECT * FROM table where name = $1;

msg.name = "Bob"
msg.params = ['Bob'] 

Output

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