MIME-Version: 1.0
References: <CA+FnnTwmt7BOqwZnsB5LOq47U+wzRc86wXaea9B0KEXfK2O+Kw@mail.gmail.com>
 <CAKFQuwa2ef9Bxz79Q8JtVNxmMABN829EJqiLKXxB5=5AEHyr9w@mail.gmail.com>
 <CAKFQuwa9PsXitAWuG1hg-8EPOu0AdB2TiANaBRJfgSrdjioa+Q@mail.gmail.com>
 <CA+FnnTz51Ond5HGkDgKvRB6ERi3pr5Q1wTnwoMK8rCwsm79_sA@mail.gmail.com> <CAKFQuwa7rK-NfVwHT7_Nob6S=GN-tKK7F1+eLQ-FQZMsW3gd8g@mail.gmail.com>
In-Reply-To: <CAKFQuwa7rK-NfVwHT7_Nob6S=GN-tKK7F1+eLQ-FQZMsW3gd8g@mail.gmail.com>
From: Igor Korot <ikorot01@gmail.com>
Date: Sat, 28 Feb 2026 19:05:39 -0600
Message-ID: <CA+FnnTw0bNsDBKFEQKsrjFZKqiZgRVZ27zhgXs5sqCLW=bwBVw@mail.gmail.com>
Subject: Re: Where the info is stored
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/CA%2BFnnTw0bNsDBKFEQKsrjFZKqiZgRVZ27zhgXs5sqCLW%3DbwBVw%40mail.gmail.com>
Precedence: bulk

Hi, David,

On Sat, Feb 28, 2026 at 7:02=E2=80=AFPM David G. Johnston
<david.g.johnston@gmail.com> wrote:
>
> On Saturday, February 28, 2026, Igor Korot <ikorot01@gmail.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=E2=80=99t have included columns.  Only indexes do.  You n=
eed to query the index, not the constraint.

I literally copied your query into my code and it didn't populated
anything...

Am I missing something?

Thank you.

>
> David J.
>