Connection Node-RED to postgreSQL server

Dashboard
1

Hello everyone,

This will be my very first post!
I want to connect Node-RED to a PostgreSQL server and for test reasons just create a table into the database. However, after configuration, I am not able to create a table. It doesn't show anything. The output on the right of the picture is from the first msg.payload. After the PostgreSQL node there is no output.

In the pictures below I will show you the configurations:
Node-RED view:

image
image1579×312 43.6 KB

Inject node:

msg.payload = CREATE TABLE student(intCarrierId INT PRIMARY KEY, intBatchId INT);

Function:

msg.queryParameters = msg.payload;
return msg;

Localhost PostgreSQL Server
Password: 1205

image
image1204×799 39.1 KB

Please, help me to find the solution!
Thanks in advance.

Tim

2

Welcome to the forum @tboekhorst

I see you have already reposted this in the General category (you could just have changed the category on this one) so I will close this one in order to avoid confusion.