pgsql-general
❮
Does WITHOUT OVERLAPS boolean stored somewhere?
- Jump to comment-1Igor Korot<ikorot01@gmail.com>Mar 28, 2026, 4:54 AM UTCHi,
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?
Thank you.- Jump to comment-1Julien Rouhaud<rjuju123@gmail.com>Mar 28, 2026, 5:05 AM UTCHi,
On Fri, Mar 27, 2026 at 11:54:12PM -0500, Igor Korot wrote:Hi,
It's the conperiod attribute of pg_constraint, see
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?
https://www.postgresql.org/docs/current/catalog-pg-constraint.html for all use
cases.- Jump to comment-1Igor Korot<ikorot01@gmail.com>Mar 28, 2026, 5:23 AM UTCJulien,
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?
Thank you.
It's the conperiod attribute of pg_constraint, see
https://www.postgresql.org/docs/current/catalog-pg-constraint.html for all use
cases.