Postgres partial unique index

[michaelstack]

Postgres supports partial unique indexes.

The relevant docs are at https://www.postgresql.org/docs/current/indexes-partial.html

I am working on a postgres database managed by dbschema. I want to create a partial unique index. It looks like these are not supported in the UI.

If this is supported in the UI could you please tell me where I should be looking in the docs? If it is not supported, is there a workaround?

[wise-coders]

In the Index dialog, use the Options combo to add the where clause:

I have checked, and this indexes are also reversed engineer correctly from the database:

[michaelstack]

That's awesome!

Thanks for the quick response.