# Postgres : Schema name in Upper Case

**URL:** <https://forum.liquibase.org/t/postgres-schema-name-in-upper-case/9993>\
**Category:** Uncategorized\
**Created:** [December 4, 2024, 12:12am UTC](https://forum.liquibase.org/t/postgres-schema-name-in-upper-case/9993 "2024-12-04T00:12:35Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dabu](https://avatars.discourse-cdn.com/v4/letter/d/c2a13f/32.png) [@Dabu](https://forum.liquibase.org/u/Dabu)\
**Post date:** [December 4, 2024, 12:12am UTC](https://forum.liquibase.org/t/postgres-schema-name-in-upper-case/9993/1 "2024-12-04T00:12:35Z")

</div>

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?