Skip to main content
5 of 6
mention exceptions
Erwin Brandstetter
  • 186.6k
  • 28
  • 465
  • 639

Yes. A UNIQUE constraint is implemented with the help of a unique index - a b-tree index with default sort ordering over all involved columns. The index is created and maintained automatically, and is used for all purposes like a plain unique index by Postgres.

There is no need to create another (redundant) unique index like it, that would be a waste of resources.

Detailed explanation:

Some rare exceptions apply for multicolumn indexes with special sort options:

Erwin Brandstetter
  • 186.6k
  • 28
  • 465
  • 639