What if someone has information on the subject? Please, if you know, don’t be silent.
There is a file XXX.json, the data of which must be saved in the field field_with_json_type of the table YYY of the postgresql database.
Changset looks like this:
<changeSet> ... <insert tableName="YYY"> ... <column name="field_with_json_type" valueClobFile="XXX.json"/> ... </insert>
I get a mistake:
org.postgresql.util.PSQLException: ERROR: column “field_with_json_type” is of type json but expression is of type character varying
I can’t believe it is there no way to tell liquibase that the column data type is json?
Or do you want the content of the file to type ::json?