Re: Where the info is stored

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(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: Where the info is stored
Date: 2026-03-01 01:02:31
Message-ID: CAKFQuwa7rK-NfVwHT7_Nob6S=GN-tKK7F1+eLQ-FQZMsW3gd8g@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Saturday, February 28, 2026, Igor Korot <ikorot01(at)gmail(dot)com> wrote:

> FROM pg_constraint co, pg_namespace n, pg_class
>
> As you can see only the constraint name and the tablespace are
> populated correctly.

Constraints don’t have included columns. Only indexes do. You need to
query the index, not the constraint.

David J.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Igor Korot 2026-03-01 01:05:39 Re: Where the info is stored
Previous Message Igor Korot 2026-03-01 00:37:34 Re: Where the info is stored