I have created the table with 5 column and inserted the records, later added the new column using “addcolumn” tag. But liquibase deleted the existing records and created new table with new column so lost all the existing data in DB
Is it possible to do add new column, change datatype of exiting column without deleting the existing records in table? If yes any documentation and steps needs to be followed?
Goal : Basically need to add new column, change datatype of exiting column dynamically without deleting the existing records, is it possible can you please share us the steps needs to be followed?
Note : I have used the postgres DB