How to create column of type double precision[] (array of doubles) with liquibase in postgresql database?
<changeSet id="add t_name table">
<createTable tableName="t_name">
...
<column name="doubleArray" type="???"/>
...
</createTable>
</changeSet>
Google didn't help, please, if someone knows a solution, I will be very appreciative.
I finally found the answer with help of my colleague. It seems that liquibase don't know such types, so we need to modify sql query manually:
<createTable tableName="t_name">
...
<column name="doubleArray" type="DOUBLE_ARRAY"/>
...
</createTable>
<modifySql dbms="postgresql">
<replace replace="DOUBLE_ARRAY" with="double precision[][]"/>
</modifySql>
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments