How to create Liquibase changeset for below Postgres index creation statement - "using btree"

1.1k views Asked by At
create index if not exists department_index 
   on department using btree (department_id);

How can I create a Liquibase changeset for the above Postgresql? I have to use "using btree" feature in order to attain the desired performance,

1

There are 1 answers

0
tabbyfoo On

The default index is btree if you don't specify something else. You can use the createIndex entity to do this.

Reference: Liquibase Documentation: createIndex