Postgres query returns invalid input syntax while updating jsonb column fields

Question and Answers Data Source
1

Screenshot 2023-01-11 at 3.50.40 PM
Screenshot 2023-01-11 at 3.50.40 PM1846×966 116 KB

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.

2

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

1 Like
3

Yes, turning off smart-substitution worked. Thanks!

4