R
Railway10mo ago
conskype

Postgres sql update query inserting "$1" instead of "?"

I have a Postgres server and I runned the query: update "Table_name" set("column_name") = ("Column_name" || E'\?') from the webpage of Railway I expected something like updating "hello" to "hello?" but it updated the rows like "hello$1".
Solution:
I have tried changing '?' for CHR(63) and it worked
Jump to solution
3 Replies
Percy
Percy10mo ago
Project ID: 816204a8-0722-45ec-a185-f5c79d0b2ecc
conskype
conskype10mo ago
816204a8-0722-45ec-a185-f5c79d0b2ecc
Solution
conskype
conskype10mo ago
I have tried changing '?' for CHR(63) and it worked