postgresql更新json/jsonp类型（Cause: org.postgresql.util.PSQLException: ERROR: column "profile" is of type json but expression is of type character varying）

背景

实体转为json字符串更新pg失败

报错信息

Cause: org.postgresql.util.PSQLException: ERROR: column "profile" is of type json but expression is of type character varying

解决