# Insert Query in postgre not working

**URL:** <https://discourse.nodered.org/t/insert-query-in-postgre-not-working/17779>\
**Category:** General\
**Created:** [11 November 2019 06:36 UTC](https://discourse.nodered.org/t/insert-query-in-postgre-not-working/17779 "2019-11-11T06:36:19Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![pranavthakkar](https://avatars.discourse-cdn.com/v4/letter/p/e99b99/32.png) [@pranavthakkar](https://discourse.nodered.org/u/pranavthakkar)\
**Post date:** [11 November 2019 06:36 UTC](https://discourse.nodered.org/t/insert-query-in-postgre-not-working/17779/1 "2019-11-11T06:36:19Z")

</div>

Hello there , Greetings ! I' working on Postgresql and I want to insert the query into it but it is not inserting into it.  
This is syntax of query  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/a/a79bff18909a78ff7e40ae165e11cfd7ffdebb87.png)

This is flow,

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/a/a66611402b326d5eb4e574ebba2dbf23b5d359dd.png)  
and this is pgadmin table

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/e/ed00cad499928b2a0d6dc02d0d82a17008605b57.png)

---

<div class="post-metadata">

**Author:** ![bakman2](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/bakman2/32/6207_2.png) [@bakman2](https://discourse.nodered.org/u/bakman2)\
**Post date:** [11 November 2019 07:04 UTC](https://discourse.nodered.org/t/insert-query-in-postgre-not-working/17779/2 "2019-11-11T07:04:13Z")

</div>

Look at the column "Title" vs "title".

---

<div class="post-metadata">

**Author:** ![pranavthakkar](https://avatars.discourse-cdn.com/v4/letter/p/e99b99/32.png) [@pranavthakkar](https://discourse.nodered.org/u/pranavthakkar)\
**Post date:** [11 November 2019 07:10 UTC](https://discourse.nodered.org/t/insert-query-in-postgre-not-working/17779/3 "2019-11-11T07:10:37Z")

</div>

I also tried that one but didn't get the anything

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/c/cc577d9f00c83889133db31fc9e1d349ce035dd3.png)

---

<div class="post-metadata">

**Author:** ![bakman2](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/bakman2/32/6207_2.png) [@bakman2](https://discourse.nodered.org/u/bakman2)\
**Post date:** [11 November 2019 07:24 UTC](https://discourse.nodered.org/t/insert-query-in-postgre-not-working/17779/4 "2019-11-11T07:24:36Z")

</div>

Did you deploy this change ?

---

<div class="post-metadata">

**Author:** ![pranavthakkar](https://avatars.discourse-cdn.com/v4/letter/p/e99b99/32.png) [@pranavthakkar](https://discourse.nodered.org/u/pranavthakkar)\
**Post date:** [11 November 2019 07:25 UTC](https://discourse.nodered.org/t/insert-query-in-postgre-not-working/17779/5 "2019-11-11T07:25:56Z")

</div>

Yes this is after photo

---

<div class="post-metadata">

**Author:** ![bakman2](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/bakman2/32/6207_2.png) [@bakman2](https://discourse.nodered.org/u/bakman2)\
**Post date:** [11 November 2019 07:28 UTC](https://discourse.nodered.org/t/insert-query-in-postgre-not-working/17779/6 "2019-11-11T07:28:26Z")

</div>

rename your column to `title` - lowercase unless you want to deal with:

> All **identifiers** (including column names) that are not double-quoted are folded to lower case in PostgreSQL. Column names that were created with double-quotes and thereby retained upper-case letters (and/or other syntax violations) have to be double-quoted for the rest of their life: ( `"first_Name"` )

small tip: use SERIAL PRIMARY KEY for the `id` field, then you don't have to insert a number and it will be autogenerated.

---

<div class="post-metadata">

**Author:** ![pranavthakkar](https://avatars.discourse-cdn.com/v4/letter/p/e99b99/32.png) [@pranavthakkar](https://discourse.nodered.org/u/pranavthakkar)\
**Post date:** [11 November 2019 07:31 UTC](https://discourse.nodered.org/t/insert-query-in-postgre-not-working/17779/7 "2019-11-11T07:31:46Z")

</div>

after changing Title to title in pgadmin what should the value look like i got an error on it.

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/5/540a21684fb73b2710cb1a9dacac8368eaf40ec4.png)

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/7/71296a8c419f7cbb02c18eebdb823db6acdbbe99.png)

---

<div class="post-metadata">

**Author:** ![pranavthakkar](https://avatars.discourse-cdn.com/v4/letter/p/e99b99/32.png) [@pranavthakkar](https://discourse.nodered.org/u/pranavthakkar)\
**Post date:** [11 November 2019 07:34 UTC](https://discourse.nodered.org/t/insert-query-in-postgre-not-working/17779/8 "2019-11-11T07:34:25Z")

</div>

but if i give it as parameter it got successful on it.

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/e/e24d66b8ddcd1eaeda8da5084969b74c00bd004e.png)

---

<div class="post-metadata">

**Author:** ![bakman2](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/bakman2/32/6207_2.png) [@bakman2](https://discourse.nodered.org/u/bakman2)\
**Post date:** [11 November 2019 07:36 UTC](https://discourse.nodered.org/t/insert-query-in-postgre-not-working/17779/9 "2019-11-11T07:36:27Z")

</div>

because you used backticks and postgres will assume that is a column.

i cannot copy your code (screenshot) but you need to use double quotes for the query and in your query use single quotes for strings, ie.:

```auto
query: "insert into test (title) values ('test4')"

```

(assumes autokey generation for id)

---

<div class="post-metadata">

**Author:** ![pranavthakkar](https://avatars.discourse-cdn.com/v4/letter/p/e99b99/32.png) [@pranavthakkar](https://discourse.nodered.org/u/pranavthakkar)\
**Post date:** [11 November 2019 07:38 UTC](https://discourse.nodered.org/t/insert-query-in-postgre-not-working/17779/10 "2019-11-11T07:38:07Z")

</div>

Thank you It is working now