postgresql - Liquibase(Postgres): Add uniqiue constraint with ignore case

Question

I would like to add a unique constraint on a column of type varchar using liquibase on a postgres table, but could not find an option. It does not allow me to use UPPER or LOWER for a column name. e.g.

<addUniqueConstraint columnNames="column_a, column_b, upper(column_c)"
                             deferrable="true" initiallyDeferred="true" disabled="false"
                             constraintName="constraint_uk" tableName="table_a"/>

question from:https://stackoverflow.com/questions/65892173/liquibasepostgres-add-uniqiue-constraint-with-ignore-case

Answer 1

Waitting for answers