I’m trying to get started with LiquiBase 1.9.5 and calling generateChangeLog to get an initial file on an existing PostgreSQL (8.3/8.4) database. Problem I’m having is they have tables in different schema, other then public. Example table names are schemax.users, schemay.products. In the database in question, no tables are in the public instance. Does LiquiBase work with multiple active schema paths? Can I configure it to at least manipulate a specific schema path?
I was able to get liquibase working with a regular database who’s tables are in the public schema just fine. I tried setting the postgres.conf file so by default all schemas would be in the searchpath. Looking at the resulting SQL code generated by liquibase, the public schema is the only one being looked at. Can anyone provide any pointers?