PostgreSQL Node: Fixed String $1 Misinterpreted as Placeholder in Execute Query Operation about n8n HOT 3 OPEN

That value makes perfect sense, This is in the queue to be picked up so should be resolved soon.

from n8n.

Thanks for the report, I have managed to reproduce this and have created NODE-1416 as the internal ticket to get this fixed. Out of interest and so we can set a priority to it... Do you use $x a lot in your queries?

from n8n.

I think this issue is critical for PostgreSQL becasue the issue prevents the execution of very common SQL such as the following example:
insert into comments (id, text) values (2, "His efforts have resulted in a $1000 salary increase.”)

Of course, this problem can be bypassed by using a PREPARED STATEMENT as follows.
insert into comments (id, text) values (2, $1)
Query parameters: "His efforts have resulted in a $1000 salary increase.”

from n8n.