Re: Where the info is stored

On Sat, Feb 28, 2026 at 6:34 PM Igor Korot <ikorot01(at)gmail(dot)com> wrote:

> And why there is no WHERE populated?
>
> Thank you.
>
> On Sat, Feb 28, 2026 at 7:05 PM Igor Korot <ikorot01(at)gmail(dot)com> wrote:
> >
> > Hi, David,
> >
> > On Sat, Feb 28, 2026 at 7:02 PM David G. Johnston
> > <david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
> > >
> > > 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.
> >
> > I literally copied your query into my code and it didn't populated
> > anything...
> >
> > Am I missing something?
>
>
I trimmed your query to emphasize/point-out that you were querying
pg_constraint and that doing so to find included columns is doomed to
failure (I suppose it could have been used to find the index, but in this
case it wasn't. I haven't explored that approach.). You should step back
and consider why you thought the fragment I included in my reply, a bare
FROM clause, would somehow be executable since it is in no way a valid
query.

David J.