We are unable to figure out how to handle population of static data with identity (auto increment) column and foreign key column. Say for example, we have two static tables,
Id (Primary key and identity), short name, name
Id (Primary key and identity), Table1.Id(foreign key), details
What is the better way to populate data in the above tables on every version release using Liquibase? In the above example, using Liquibase, how do we get value of primary key column in order to insert as foreign key of second table?
We are using Postgres database.