Liquibase: Copy column data into a new column in the same table

sql database liquibase
sindhunk picture sindhunk · Mar 31, 2016 · Viewed 8.7k times · Source

I have a table with a column A. I am creating a new column B. B will have the same data as column A. How do I replicate the column in Liquibase? Is there some expression I can write to do the replication?

Answer

Tim Biegeleisen picture Tim Biegeleisen · Mar 31, 2016

Create a new changeset where you add a new column, and then update column B using the <sql> tag:

<changeSet author="yourName" id="example">
    <addColumn catalogName="db"
               schemaName="public"
               tableName="yourTable">
        <!-- replace varchar(255) with the actual type of column A -->
        <column name="B" type="varchar(255)"/>
    </addColumn>

    <sql>UPDATE yourTable SET B = A</sql>
</changeSet>

Related questions

Update one row in the table, using liquibase

I was hoping if someone could verify if this is the correct syntax and correct way of populating the DB using liquibase? All, I want is to change value of a row in a table and I'm doing it like …

Read More
Inserting lots of values (with FK's) into database using LiquiBase and Spring

I'm trying to add a lot of records (currently located in an Excel file) into my DB using Liquibase (so that I know how to do it for future DB changes) My idea was to read the excel file using …

Read More
With Liquibase, is there a difference between using a unique <createIndex> and using <column> with a unique constraint?

Liquibase has two ways to define a column as unique: When creating the table, using <constraints> on the column: <createTable tableName="my_table"> <column name="my_column"> <constraints unique="true" uniqueConstraintName="my_table_…

Read More