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.