In our postgres setup , the schema names are in upper so we always refer it using double quotes (“SAP_DATA”) . I am trying to run DIFF from the command line but not getting anything as the Liquibase is comparing with lower case schema name.
Below is the command I am running :
liquibase --url=“jdbc:postgresql://locathost:5432/postgres” --username=postgres --password=<> --reference-url=“jdbc:postgresql://:5432/postgres” DIFF --reference-username=postgres --reference-password=<> --referenceDefaultSchemaName=“SAP_DATA” --default-schema-name=“SAP_DATA”
In the diff out below, the schema is being compared with sap_data even after I am giving “SAP_DATA” as schema on the command line.
Diff Results:
Reference Database: postgres @ jdbc:postgresql:/locathost/5433/OST (Default Schema: sap_data)
Comparison Database: postgres @ jdbc:postgresql://locathost:5433/OST (Default Schema: sap_data)
Can someone pls help how can I overcome this issue?