Re: Unique index

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Unique index
Date: 2023-09-20 14:14:52
Message-ID: 3983831447229a17fc9028fd2f5b2aaf0996c291.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, 2023-09-20 at 19:16 +0530, Rajesh Kumar wrote:
> Why unique index is used over unique constraints?

A unique constraint is implemented by a unique index.
If you create the constraint, the index is created automatically.
You cannot drop the index unless you drop the constraint.

Yours,
Laurenz Albe

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Erik Wienhold 2023-09-20 16:45:34 Re: Unique index
Previous Message Rajesh Kumar 2023-09-20 13:46:36 Unique index