R
Railway

✋|help

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

Cconskype8/28/2023
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
Cconskype8/28/2023
816204a8-0722-45ec-a185-f5c79d0b2ecc
Solution
Cconskype8/28/2023
I have tried changing '?' for CHR(63) and it worked

Looking for more? Join the community!

Recommended Posts