And why there is no WHERE populated? Thank you.
On Sat, Feb 28, 2026 at 7:05 PM Igor Korot <[email protected]> wrote: > > Hi, David, > > On Sat, Feb 28, 2026 at 7:02 PM David G. Johnston > <[email protected]> wrote: > > > > On Saturday, February 28, 2026, Igor Korot <[email protected]> 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. > >
