Liquibase Spatial – Change: insert

Change: ‘insert’

The <insert> change works the same as before except that Well-Known Text and Extended Well-Known Text formats are supported.

As a Best Practice, use the Extended Well-Known Text format and match the SRID to the value given in the column’s geometry column type.

Example

<changeSet id="1" author="bob">
   <insert tableName="home">
      <column name="id" valueNumeric="1" />
      <column name="location" value="POINT(-106.445305 39.117769)" />
   </insert>
   <insert tableName="home">
      <column name="id" valueNumeric="1" />
      <column name="location" value="SRID=4326;POINT(-106.445305 39.117769)" />
   </insert>
</changeSet>