So, some good news guys - I found a working PostgreSQL node it's called 'node-red-contrib-postgrestor-next' here is the results:
Here is my table called 'dev'
This is great news, at least this is working but now comes the real reason for getting a working PostgreSQL node...
I want to inject the results of an API call into the database table called 'sensors', here is what is happening in the flow which is bypassing the PostgreSQL node for now:
Here is my PostgreSQL command:
INSERT INTO SENSORS (id, device_id, name, unit) VALUES ('{{payload.id}}', '{{payload.deviceId}}', '{{payload.name}}', '{{payload.unit}}');
The results are strange, all I get is a load of empty rows 
What am I not doing correctly here?
Many thanks!
