Re: Where the info is stored - Mailing list pgsql-general

Hi, David,

On Sat, Feb 28, 2026 at 7:02 PM 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’t have included columns.  Only indexes do.  You need 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.
>