Hi,
I have been reading about "unique constraint" and "unique index" in
PostgreSQL documentation and also did some search in Google. However, it is
not very clear to me which one to use or when to use one or the other. I
understand that a "unique constraint" creates a "unique index" under the
hood. So, at the end, both will check for duplicate records based on the
field(s) specified for the unique constraint and the unique index.
What would be a guideline about when to use one or the other?
Respectfully,
Jorge Maldonado