# Postgresql - how can I create table

**URL:** <https://discourse.nodered.org/t/postgresql-how-can-i-create-table/51273>\
**Category:** General\
**Created:** [20 September 2021 08:56 UTC](https://discourse.nodered.org/t/postgresql-how-can-i-create-table/51273 "2021-09-20T08:56:12Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![vishnupriya](https://avatars.discourse-cdn.com/v4/letter/v/e9c0ed/32.png) [@vishnupriya](https://discourse.nodered.org/u/vishnupriya)\
**Post date:** [20 September 2021 08:56 UTC](https://discourse.nodered.org/t/postgresql-how-can-i-create-table/51273/1 "2021-09-20T08:56:12Z")

</div>

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

 ![Screenshot (117)](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/a/2/a2784252b4e94b50a57c5883f7289d801066d8ae.png)

Inject Node is given below

 ![Screenshot (118)](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/8/1/8143021ae2c315a0594071096b3747bf29f4b5aa.png)  
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.

---

<div class="post-metadata">

**Author:** ![vishnupriya](https://avatars.discourse-cdn.com/v4/letter/v/e9c0ed/32.png) [@vishnupriya](https://discourse.nodered.org/u/vishnupriya)\
**Post date:** [20 September 2021 09:03 UTC](https://discourse.nodered.org/t/postgresql-how-can-i-create-table/51273/2 "2021-09-20T09:03:14Z")

</div>

This is my function node

 ![Screenshot (119)](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/c/2/c24b0c44c0c5eae54f27c82e9759235fb9ff713b.png)  
this is my postgresql node  
 ![Screenshot (120)](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/7/8/782df8c4db4f9239ff6b0e6e6a497773ccc8696c.png)

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [19 November 2021 09:03 UTC](https://discourse.nodered.org/t/postgresql-how-can-i-create-table/51273/3 "2021-11-19T09:03:16Z")

</div>

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