Multicolumn Indices

[tobymao]

Is there a way to define multi-column indices?

In SQLAlchemy it's normally done as

Index('myindex', mytable.c.col5, mytable.c.col6, unique=True)

[tobymao]

`
class Meta:

    constraints = [

        
          sqlalchemy.Index('idx_a_b', 'a', 'b')

    ]

`

seems to be what i want, is this correct?

[collerek]

Correct, that is what you are looking for but you need to use the ormar UniqueColumns and not the sqlalchemy index.
https://collerek.github.io/ormar/models/#constraints

[tobymao]

thanks

[tobymao]

but what if i don't want them to be unique?

[collerek]

Then it's an enhancement, should be relatively easy to add (in a similar fashion as UniqueColumn constraint).
You can open an enhancement issue if you need this one.