Re: Does WITHOUT OVERLAPS boolean stored somewhere?

From: Julien Rouhaud <rjuju123(at)gmail(dot)com>
To: Igor Korot <ikorot01(at)gmail(dot)com>
Cc: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Does WITHOUT OVERLAPS boolean stored somewhere?
Date: 2026-03-28 05:04:56
Message-ID: acdheJh41B7sM2PG@jrouhaud
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Igor Korot 2026-03-28 05:23:14 Re: Does WITHOUT OVERLAPS boolean stored somewhere?
Previous Message Igor Korot 2026-03-28 04:54:12 Does WITHOUT OVERLAPS boolean stored somewhere?