PostgreSQL: Insert into JSONB key failing with syntax error at or near "->>"
The reason is that the attributes of a JSON column are not database columns, so you cannot use them in the SET clause of an UPDATE statement.
You can only replace the complete JSON with an UPDATE statement.
It might be a good idea to use regular &quot;scalar&quot; database columns instead of lumping several attributes together into a JSON if you want to modify them individually.