# Create data in postgres
**URL:** https://discourse.nodered.org/t/create-data-in-postgres/45063
**Category:** General
**Created:** [2 May 2021 15:39 UTC](https://discourse.nodered.org/t/create-data-in-postgres/45063 "2021-05-02T15:39:13Z")
**Posts on this page:** 16
**Page:** 1
### Author:  [@grandautism](https://discourse.nodered.org/u/grandautism)
#### Post date: [2 May 2021 15:39 UTC](https://discourse.nodered.org/t/create-data-in-postgres/45063/1 "2021-05-02T15:39:14Z")
hello, I am using the node red for the first time, I try to stock data in postgresql.
I currently need to find a solution, but nothing works, can you tell me what i do wrong ?
function insert:
---
### Author:  [@zenofmud](https://discourse.nodered.org/u/zenofmud)
#### Post date: [2 May 2021 15:42 UTC](https://discourse.nodered.org/t/create-data-in-postgres/45063/2 "2021-05-02T15:42:16Z")
The first thing you need to do is tell us what you have tried
---
### Author:  [@grandautism](https://discourse.nodered.org/u/grandautism)
#### Post date: [2 May 2021 15:48 UTC](https://discourse.nodered.org/t/create-data-in-postgres/45063/3 "2021-05-02T15:48:22Z")
I started with a simple program but it didn't work
nothing is displayed in my postgres
---
### Author:  [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)
#### Post date: [2 May 2021 15:56 UTC](https://discourse.nodered.org/t/create-data-in-postgres/45063/4 "2021-05-02T15:56:39Z")
> [@grandautism](#):
>
> I currently need to find a solution, but nothing works, can you tell me what i do wrong
What node is it. Have you read the built in help? Have you read the readme for that node?
I ask because many of the SQL nodes expect the query to be in topic.
---
### Author:  [@grandautism](https://discourse.nodered.org/u/grandautism)
#### Post date: [2 May 2021 17:09 UTC](https://discourse.nodered.org/t/create-data-in-postgres/45063/5 "2021-05-02T17:09:02Z")
i used the node-red-contrib-postgrestor-next biblio.
must I add a function or something like that ?
if anyone has already send data to postgres, can you share with me your code ?
---
### Author:  [@zenofmud](https://discourse.nodered.org/u/zenofmud)
#### Post date: [2 May 2021 18:11 UTC](https://discourse.nodered.org/t/create-data-in-postgres/45063/6 "2021-05-02T18:11:59Z")
What settings do you have in the node-red-contrib-postgrestor-next node?
---
### Author:  [@grandautism](https://discourse.nodered.org/u/grandautism)
#### Post date: [2 May 2021 18:41 UTC](https://discourse.nodered.org/t/create-data-in-postgres/45063/7 "2021-05-02T18:41:55Z")
here is my node's setting
I tried node-red-contrib-re-postgres biblio, same prob
---
### Author:  [@zenofmud](https://discourse.nodered.org/u/zenofmud)
#### Post date: [3 May 2021 00:16 UTC](https://discourse.nodered.org/t/create-data-in-postgres/45063/8 "2021-05-03T00:16:48Z")
So is Postgres installed on the same device that node-red is?
---
### Author:  [@grandautism](https://discourse.nodered.org/u/grandautism)
#### Post date: [3 May 2021 09:02 UTC](https://discourse.nodered.org/t/create-data-in-postgres/45063/9 "2021-05-03T09:02:19Z")
yes, on the same device.. do i should add something else ?
---
### Author:  [@zenofmud](https://discourse.nodered.org/u/zenofmud)
#### Post date: [3 May 2021 09:40 UTC](https://discourse.nodered.org/t/create-data-in-postgres/45063/10 "2021-05-03T09:40:39Z")
I just wanted to make sure it was on the same device. Now what is your query?
Have you read the nodes read me?
---
### Author:  [@grandautism](https://discourse.nodered.org/u/grandautism)
#### Post date: [3 May 2021 10:31 UTC](https://discourse.nodered.org/t/create-data-in-postgres/45063/11 "2021-05-03T10:31:24Z")
I found where is the problem, the code should be inserted inside the potgres node
My query is like that:
msg.params = ['{{payload.id}}', '{{payload.value}}']
return msg;
---
### Author:  [@zenofmud](https://discourse.nodered.org/u/zenofmud)
#### Post date: [3 May 2021 11:41 UTC](https://discourse.nodered.org/t/create-data-in-postgres/45063/12 "2021-05-03T11:41:28Z")
Congradulations!!
---
### Author:  [@grandautism](https://discourse.nodered.org/u/grandautism)
#### Post date: [3 May 2021 11:56 UTC](https://discourse.nodered.org/t/create-data-in-postgres/45063/13 "2021-05-03T11:56:45Z")
yhank you but it didn't work with multiple inputs
---
### Author:  [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [3 May 2021 13:31 UTC](https://discourse.nodered.org/t/create-data-in-postgres/45063/14 "2021-05-03T13:31:51Z")
There is no point saying that unless you show us what doesn't work and in what way it doesn't work.
---
### Author:  [@grandautism](https://discourse.nodered.org/u/grandautism)
#### Post date: [3 May 2021 14:36 UTC](https://discourse.nodered.org/t/create-data-in-postgres/45063/15 "2021-05-03T14:36:39Z")
I serve the problem, thank you all
---
### Author:  [@nurmosfet](https://discourse.nodered.org/u/nurmosfet)
#### Post date: [8 October 2021 01:45 UTC](https://discourse.nodered.org/t/create-data-in-postgres/45063/16 "2021-10-08T01:45:28Z")
Hai... have you solved it ?
if you don't mind please what you have done to solved it..
i have the same issue.. thanks