Hi there!
I tested this solution & it seems to work well for jsonb 
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Invalid input syntax for type json with jsonb column | 2 | 8893 | May 6, 2024 | |
| Double brackets not working as expected when querying jsonb column in postgres database | 4 | 2057 | August 2, 2023 | |
| Updating jsonb column | 8 | 9347 | December 28, 2023 | |
| Bug in running jsonb field update query in postgresql | 3 | 709 | August 3, 2023 | |
| MongoDB - 'Must be valid JSON' Error | 8 | 3439 | August 2, 2023 |