Postgres query returns invalid input syntax while updating jsonb column fields

I am trying to update fields of a jsonb column with postegres query, but it keeps giving me error for invalid input syntax. Similar query works on my local postgres client.

Can you turn off the smart-substitution setting and then try?

1 Like

Yes, turning off smart-substitution worked. Thanks!