# Problem with Postgresql node and html

**URL:** https://discourse.nodered.org/t/problem-with-postgresql-node-and-html/72750
**Category:** General
**Created:** [26 December 2022 22:08 UTC](https://discourse.nodered.org/t/problem-with-postgresql-node-and-html/72750 "2022-12-26T22:08:05Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Lafayette](https://avatars.discourse-cdn.com/v4/letter/l/47e85d/32.png) [@Lafayette](https://discourse.nodered.org/u/Lafayette)
#### Post date: [26 December 2022 22:08 UTC](https://discourse.nodered.org/t/problem-with-postgresql-node-and-html/72750/1 "2022-12-26T22:08:05Z")

</div>

Hi,

I have a problem. I want to save some data in a postgresql database. In my table, I have a Text column and I use the node-red-contrib-postgresql node (last version with Nore Red uptodate) to send data from nodered to the database but while the original text is correct just before the injection, in the database some characters like ' or / are replaced by "&#x2F"; or "&#39"; . When I modify manually the data in the database I can write a sentence with these characters without problem.  
If someone has an idea ...  
Thx.

---

<div class="post-metadata">

### Author: ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [27 December 2022 12:51 UTC](https://discourse.nodered.org/t/problem-with-postgresql-node-and-html/72750/2 "2022-12-27T12:51:48Z")

</div>

Are you sure it is not the query that is at fault?  
Please feed the message that you are sending to the postgres node into a debug node so we can see the query you are sending.

---

<div class="post-metadata">

### Author: ![Lafayette](https://avatars.discourse-cdn.com/v4/letter/l/47e85d/32.png) [@Lafayette](https://discourse.nodered.org/u/Lafayette)
#### Post date: [27 December 2022 23:09 UTC](https://discourse.nodered.org/t/problem-with-postgresql-node-and-html/72750/3 "2022-12-27T23:09:33Z")

</div>

Hi,

I have found the problem. It is because Mustache converts the specials characters automatically ... To avoid that, we have to use {{{ .... }}} instead of {{...}} in the script.

---

<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: [10 January 2023 23:09 UTC](https://discourse.nodered.org/t/problem-with-postgresql-node-and-html/72750/4 "2023-01-10T23:09:55Z")

</div>

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