0
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 is nothing special about this index. `btree` is the default if nothing else is specified. Just use `` –  May 06 '22 at 19:12

1 Answers1

0

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

tabbyfoo
  • 355
  • 1
  • 8