Re: Does WITHOUT OVERLAPS boolean stored somewhere? - Mailing list pgsql-general

From Julien Rouhaud
Subject Re: Does WITHOUT OVERLAPS boolean stored somewhere?
Date
Msg-id acdheJh41B7sM2PG@jrouhaud
Whole thread Raw
In response to Does WITHOUT OVERLAPS boolean stored somewhere?  (Igor Korot <ikorot01@gmail.com>)
Responses Re: Does WITHOUT OVERLAPS boolean stored somewhere?
List pgsql-general
Hi,

On Fri, Mar 27, 2026 at 11:54:12PM -0500, Igor Korot wrote:
> Hi,
> I can use WITHOUT OVERLAPS when creating the PK.
>
> But is it stored somewhere?
>
> I mean can I write a query like "SELECT without_overlaps FROM ..."
> and get the value of T/F or 1/0 which will indicate if the clause was used?

It's the conperiod attribute of pg_constraint, see
https://www.postgresql.org/docs/current/catalog-pg-constraint.html for all use
cases.



pgsql-general by date:

Previous
From: Igor Korot
Date:
Subject: Does WITHOUT OVERLAPS boolean stored somewhere?
Next
From: Igor Korot
Date:
Subject: Re: Does WITHOUT OVERLAPS boolean stored somewhere?