Specifies a list of columns for the index.

Also see {@link column} for adding a single column or {@link expression} for specifying an arbitrary expression.

Examples

await db.schema
        .createIndex('person_first_name_and_age_index')
        .on('person')
        .columns(['first_name', 'age desc'])
        .execute()

The generated SQL (PostgreSQL):

create index "person_first_name_and_age_index" on "person" ("first_name", "age" desc)