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

Julien,

On Sat, Mar 28, 2026 at 12:05 AM Julien Rouhaud <rjuju123@gmail.com> wrote:
>
> 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.

Thank you.