case sensitive tables

General Discussion
1

If you run liquibase on HSQLDB to create a table named blob for example, it will generate the table “blob”. This is because blob is a keyword so the generated SQL looks something like CREATE TABLE “blob”, which in HSQLDB means the table will be in lowercase. Is there a way to specify that I want the tables to be in uppercase?(other than modifying the changeLogs)

2

Liquibase doesn’t do anything with the case of what is passed in. If you want the table uppercase, you either have to change it in the changelog file or create a custom subclass of HsqlDatabase that overrides the escapeDatabaseObject to uppercase it. See liquibase.org/extensions on how to register custom databases.


Nathan

3

That makes total sense. Thanks! FYI I’ve decided just not to name the table names keywords like blob and property, just makes every1s life easier


Suneet