How can we create a table using liquibase from a subset of existing table? If I do not want to run SQL from liquibase as below.
create table table1 as (select col1,col2,col3 from table2);
How can we create a table using liquibase from a subset of existing table? If I do not want to run SQL from liquibase as below.
create table table1 as (select col1,col2,col3 from table2);
There is no built in support with the change tags to do that. You will just have to use:
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Exporting specific table | 0 | 361 | September 28, 2012 | |
| Moving a table from one schema to another | 1 | 1331 | March 29, 2011 | |
| Augmenting existing change with additional properties | 4 | 612 | November 17, 2010 | |
| Liquibase - Data Subset Request | 0 | 378 | September 8, 2017 | |
| Drop and recreate table if changeset of create table changes | 4 | 8424 | October 30, 2023 |