# Insert into postgre db

**URL:** <https://discourse.nodered.org/t/insert-into-postgre-db/41150>\
**Category:** General\
**Created:** [17 February 2021 11:09 UTC](https://discourse.nodered.org/t/insert-into-postgre-db/41150 "2021-02-17T11:09:30Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ie-lu](https://avatars.discourse-cdn.com/v4/letter/i/45deac/32.png) [@ie-lu](https://discourse.nodered.org/u/ie-lu)\
**Post date:** [17 February 2021 11:09 UTC](https://discourse.nodered.org/t/insert-into-postgre-db/41150/1 "2021-02-17T11:09:31Z")

</div>

Hi community,

I am using node red 1.2.6 and a POSTGRESQL13 db and want to insert values into the db with the node "postgrestor".

My query within the node:  
INSERT INTO tightnesstest (diffpressure, carrier, toolid, tsp) VALUES($1, $2, $3, $4);

Table tightnesstest has 4 columns:

- diffpressure varchar[255]
- carrier int  
-toolid int  
-tsp timestamp

With the command line I can write an read the table with e.g. the query "INSERT INTO tightnesstest (diffpressure, carrier, toolid, tsp) VALUES(22,12,12345,'2021-02-16');", but with the node "postgrestor" I can not and I do not receive any error message.

Has anybody an idea why?

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/6/0/60d03404e6b9186a854fc40151949e3c2d5e62b9.png)

---

<div class="post-metadata">

**Author:** ![Nxito](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/nxito/32/88293_2.png) [@Nxito](https://discourse.nodered.org/u/Nxito)\
**Post date:** [1 March 2021 16:00 UTC](https://discourse.nodered.org/t/insert-into-postgre-db/41150/2 "2021-03-01T16:00:46Z")

</div>

I have problems with the same  
I activate the flow but I do not receive an agglome response from the node.  
any news about this ??  
did you manage to solve it?

edit: i founded this and it works for me [@open-kappa/node-red-contrib-mydb](https://flows.nodered.org/node/@open-kappa/node-red-contrib-mydb)

---

<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:** [30 April 2021 16:00 UTC](https://discourse.nodered.org/t/insert-into-postgre-db/41150/3 "2021-04-30T16:00:59Z")

</div>

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