Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vwVCh-00AtdK-2F for pgsql-general@arkaria.postgresql.org; Sun, 01 Mar 2026 01:02:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vwVCe-00Bu2p-2X for pgsql-general@arkaria.postgresql.org; Sun, 01 Mar 2026 01:02:36 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vwVCe-00Bu2g-1S for pgsql-general@lists.postgresql.org; Sun, 01 Mar 2026 01:02:36 +0000 Received: from mail-ot1-x332.google.com ([2607:f8b0:4864:20::332]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vwVCb-00000001rkW-1GjA for pgsql-general@lists.postgresql.org; Sun, 01 Mar 2026 01:02:35 +0000 Received: by mail-ot1-x332.google.com with SMTP id 46e09a7af769-7d4c1d2123dso4055186a34.2 for ; Sat, 28 Feb 2026 17:02:34 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1772326953; cv=none; d=google.com; s=arc-20240605; b=ic4EeVmLUbRD8heY9pM+fjaRfxfn8nbCQLGYW/RxUBOsnD6zqWPfeONJurT/5Jj3C2 vHfnFZSOrnVr1F89Gprk/a7uq2e6Czej3gPVN1tyzmfGSN9pv6VzQj794dYGPXfymp+V ULm7VIbS9Ork6RldRwzamkZEjOTh0J4kAoIpfBV+u0WSYwM+WYjhAOd6Djf8FQIGbD7X GMIJd4Fre5NGZCUv2jTR2sO/+Qut/oiwoh8xyh90Wx/3s/GPz1EpTtbx4sLjHIcZZ2mz nrP4n7g5ht0TSgoDaPwhtVERS/GMm/MSa74qgTieupkgUr9nx0FF10wW5gOcU1vbtD72 v/5A== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:dkim-signature; bh=FzQmvziQAACSa9EF+l1bgMX5TDZ3wporrYv6dXMDNqY=; fh=MqX3/PjeIRWyveucHIwmT3MEzIvphFWgoM5FEnVDTkI=; b=j8O9Nqpt4QLo0LFYaroBUR6E5/x4t4159WhpfDGJX8i0hEpwOfV607CGyf0XXLg62I s0rrSvo4fXD3ARnQ7lD3XJEZmldpm+4ZRonuL4rtfP6SXtof1ke8UFfOumn3m2xkaMfs Z1w32/86AuXbAIoUjcK+KeylVcVH4IValSkagn+6O16Qo3+buvt62DXURqP/2FObNapM Y8GfpujND27AfgcoRt864YGTFlh9afnktssndm5ARuQepQ8t41aIOZEzDPqX5eh5VZ8+ WebLRsI9OR7ehYoeaQVRiOZskxXo6OJkpteN9NFd2DMKM0Lj6qEubVGsdsf160lUPMe/ BifQ==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1772326953; x=1772931753; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=FzQmvziQAACSa9EF+l1bgMX5TDZ3wporrYv6dXMDNqY=; b=LU0s+BlpH3Ktm6QCkhEF9V5iZIh521wvRvLzg8n2pF4uUgFkJKuIg6y9bVkH0LA5k7 HqYhjcrekfqNpUMaCqJwk9ilDm1Y1/uDx85m7kOwKoLnvqJByiq7XG8Gaowatg34MMWk 9lwrZa3u5EeLJxK7gtL6ZnbZBEXnd//Z8VwTPaT8TMc5Pg8sDC/RJQIXNsZJctWfy7l5 1yiOROzoCvWo9v3LLpo8IQP4rWuOhHMR1jbtgIdBJsK+sn8ZB09tfveDerBS64buWRIO HhK8um5jQn1Du0hLou5ZxVWYqCm8ATXxWJWV+kxadaXzuKmDsjrJWUvNf4M8OYyrTqDn uIjA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1772326953; x=1772931753; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=FzQmvziQAACSa9EF+l1bgMX5TDZ3wporrYv6dXMDNqY=; b=Xe0XAQlQDwKRh8h9dPPCoRTZNNT0KRkPflZFw58vywTAmeyd/rX+TbNNN9G5u6Beq7 OQ17/aO5pXyIubmWuLZdP1f/eC2tUqilZwCb7AjZSJV6iCnkR5NYFUO39ix6uy4CZ+C8 AUi/xEZuTugaGjQWJYcjHZiYHcTtlVNsoYEtqKB/GgWLEFw8ph9XcTKR7SfFm+6VjROc wtJat01mfRQgl7wjKZIlCfkGtQfp1hYlFogTJN4HRm9YOv1+kGt/LtacLkFao0GRhC3u TY3npO418sbnPquycQoyyEFd17sYYUI5O73KwOEQdo/yy5fmggQn49pwy+nNYGgBIDqj l//A== X-Gm-Message-State: AOJu0Yy8JJH5z25+DKkqQ+AVbtdMRXXUOGB94F8w9D11fObFbpBCCVrP 4HcCN6X8SP5JG7b8WqSVZDiUYFCZTVXaIit9MT3BvH6B5fsV9TQHaLI+kafRPOaYV56ukl9xSE/ cyaMnx2KQIMvXzElHWzDYyqYRKY576u0= X-Gm-Gg: ATEYQzw19mClIh4NdMxZqq93Fccnuc7AJvRLvPvGcYi+ul6bViXxAwTZQf6xReqpZ8W Lhcjv6vhIbve5vgStGZI+bZTAXpIYfZx4kol61z8CR2TQmOMVxJJNxxrRMUom3w0SNWPVraMfpn qp1HDVv5YpFN0IFrXn5cKWaVGjJRuic+HyUsIsWJD1gymm7ozjJ1BSRQoOfG5ISE7szfuGEwPAA WDp9PSfe8jQ6VZfzlvfFxDCGeQQNAhBrWaqs31QD61/uOH4LA51GhxkVDZxVjX5y3JZcpjjWg9K S7zjftRtOOAmwNOBww== X-Received: by 2002:a05:6870:d410:b0:3d2:5ad4:4e7 with SMTP id 586e51a60fabf-4162704f7bamr5162347fac.47.1772326953122; Sat, 28 Feb 2026 17:02:33 -0800 (PST) MIME-Version: 1.0 Received: by 2002:a05:6802:4a17:b0:61f:9804:87cf with HTTP; Sat, 28 Feb 2026 17:02:31 -0800 (PST) In-Reply-To: References: From: "David G. Johnston" Date: Sat, 28 Feb 2026 18:02:31 -0700 X-Gm-Features: AaiRm51WB7CFqj-5Vy0_iD2CB5edHqNONG0hCEUVlBi5hx0e3VvMnTF-yE-QzG4 Message-ID: Subject: Re: Where the info is stored To: Igor Korot Cc: "pgsql-generallists.postgresql.org" Content-Type: multipart/alternative; boundary="00000000000077800a064bec06e3" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000077800a064bec06e3 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Saturday, February 28, 2026, Igor Korot 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 nee= d to query the index, not the constraint. David J. --00000000000077800a064bec06e3 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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.=C2=A0 Only indexes do.=C2=A0 You need to query = the index, not the constraint.

David J.
=
--00000000000077800a064bec06e3--