Databasechangelog specify schema name postgres

General Discussion
1

hi, i want to create databasechangelog and databasechangelock tables in seperate schema instead of public in postgres, i tried but its getting created only under public. any documentation or steps to do these would be really appreciated.

2

Hi @sairamyannam ,

I believe using property liquibaseSchemaName should help you achieve the target. I haven’t given it a try but the liquibase documentation says the property value Specifies the schema name where the Liquibase tables will be located.
Have a look here : https://docs.liquibase.com/workflows/liquibase-community/creating-config-properties.html?Highlight=liquibaseSchemaName

This link also says the same : specify-schema-location-for-changelog-tables

Let me know if this helps!
Cheers!!

1 Like