sql - Blobs and Liquibase generateChangeLog -

we have started using liquibase @ our shop. use postgresql 9.3

we trying use

liquibase --difftypes=data generatechangelog 

to create changelogs our activitii tables.

these tables use bytea columns store png data. however, when run generatechangelog, value liquibase not in column. instead getting this.

 <insert tablename="act_ge_bytearray">         <column name="id_" value="148802"/>         <column name="rev_" valuenumeric="1"/>         <column name="name_" value="image/jpeg"/>         <column name="deployment_id_"/>         <column name="bytes_" value="[b@4d513b99"/>         <column name="generated_"/>     </insert> 

the actual data in bytes_ binary representation of png file. wont paste here long, can see, liquibase not copy on correct data.

is there way address generatechangelog returns whats stored in bytea column?

thanks help.

liquibase not handle blob contents well, both generatechangelog , through standard tags. part of reason because how different databases handle them varies greatly.

your best approach use generatechangelog output starting point , modify load in blob files through blocks best works database.