How can I create index with multile columns in liquibase yaml.
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