How can I create index with multile columns in liquibase yaml.
x
CREATE UNIQUE INDEX example_index ON table_test(LOWER(id), author, name)
I was trying to do something like that:
-createIndex:
-indexName: example_index
-tableName: table_test
-columns:
-column:
name: LOWER(id)
-column:
name: author
-column:
name: name
But I am getting error column 'name' is required for all columns in an index
.
I saw similar questions, but answers/examples was written in xml and it was not working for me.
Advertisement
Answer
changeSet:
id: createIndex-example
author: liquibase-docs
changes:
- createIndex:
columns:
- column:
name: zip_code
- column:
name: address
indexName: idx_address
tableName: person
Above worked for me,
https://docs.liquibase.com/change-types/community/create-index.html