Request a Demo
Home   >   mailing lists

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

From David G. Johnston
Subject Re: Where the info is stored
Date
Msg-id CAKFQuwa7rK-NfVwHT7_Nob6S=GN-tKK7F1+eLQ-FQZMsW3gd8g@mail.gmail.com
Whole thread
In response to Re: Where the info is stored  (Igor Korot <ikorot01@gmail.com>)
Responses Re: Where the info is stored
List pgsql-general
Tree view
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.

David J.

pgsql-general by date:

Previous
From: Igor Korot
Date:
Subject: Re: Where the info is stored
Next
From: Igor Korot
Date:
Subject: Re: Where the info is stored