Postgresql - how can I create table

I'm trying to create a table in my pgadmin using node-red. But I'm not getting the table in pgadmin even after deploying it.
This is my Flow

Inject Node is given below


command given in msg.payload =
CREATE TABLE public.data
(
Time serial PRIMARY KEY,Date TIMESTAMP, NameofDevice varchar,Temp integer
)
WITH (
OIDS=FALSE
);

I've Injected the node after deploying but no table is appearing in my pgadmin. I need help.

This is my function node


this is my postgresql node

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.