Re: Get info about the index - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Get info about the index
Date
Msg-id ed4a1e4f-c601-4ce1-a45e-a65547c5e286@aklaver.com
Whole thread Raw
In response to Re: Get info about the index  (Igor Korot <ikorot01@gmail.com>)
Responses Re: Get info about the index
List pgsql-general
On 8/1/25 17:06, Igor Korot wrote:
> Hi, Laurenz,

> 
> I'm looking at the pg_index table and I see it has:
> 
> [quote]
> indisexclusion bool
> 
> If true, this index supports an exclusion constraint
> [/quote]
> 
> If I read the docs correctly, this field indicates whether the
> WHERE condition is actually present.
> 
> Am I right?

No, it refers to:

https://www.postgresql.org/docs/current/ddl-constraints.html#DDL-CONSTRAINTS-EXCLUSION

> 
> Thank you.
> 
>>
>> Yours,
>> Laurenz Albe


-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: Igor Korot
Date:
Subject: Re: Get info about the index
Next
From: Jon Zeppieri
Date:
Subject: Re: Get info about the index