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 1vwZg7-00G4oG-0U for pgsql-general@arkaria.postgresql.org; Sun, 01 Mar 2026 05:49:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vwZg6-00CSiw-0O for pgsql-general@arkaria.postgresql.org; Sun, 01 Mar 2026 05:49:18 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vwZg5-00CSio-2a for pgsql-general@lists.postgresql.org; Sun, 01 Mar 2026 05:49:17 +0000 Received: from mail-oo1-xc31.google.com ([2607:f8b0:4864:20::c31]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vwZg2-00000001pWH-48Nw for pgsql-general@lists.postgresql.org; Sun, 01 Mar 2026 05:49:17 +0000 Received: by mail-oo1-xc31.google.com with SMTP id 006d021491bc7-6798f3b7163so2790080eaf.3 for ; Sat, 28 Feb 2026 21:49:15 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1772344154; cv=none; d=google.com; s=arc-20240605; b=FTUvYwDJ5UkxDZUaKx0YmlE8dMqJuY18+Ka268471u4RS3l9UKqZerC43QUnRYHrl2 zqltL39SfxB0ONLGsncan+q0dNrs4VELUifkMj9AgzG3ub+Ja7rewQDnLlR7SHpdt4jg c6wCLKC7GyZj2HrTh+MDMOfMz5vnswhnGCQH9fYR6rfrU5SoNWfX8cjQQRoVWbS0T+pb i4WZ4ZylFilLWPJZnADIAK4TeZnJTIgXLfuyQQ7KsdGOGUaMLAEiLJ/1qJZAQyjwiadS rn2ybqguWnfwAQ+gDmLOp5ufDTmIyULjFm/6+kjwHiFD9GKOJ+NpNXx2QyLdgYjF8X/6 39WQ== 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=MKznFuVGnlK93q7ZBFPEY1HZ3DiPzjCwQhJWJgfjWYA=; fh=MqX3/PjeIRWyveucHIwmT3MEzIvphFWgoM5FEnVDTkI=; b=ZnRMxX5ZHJ/LHernQCHfqIoxBzvkJsCmzUZ4GdDONZ0PkZe3tmZO38IwGsSaV5STAX b1pYUIeDez4SPcSeoFLyBwndSRQnIzOUEiZM+NgdyitQ6MzdpBQAuHkRtw5H08Fr93By NHfcFILgTct3KSsq5lz23xjVl8li+/V8T/JSjdwkGHwN+p32muV3q5kiV4uXP6agHIo7 icfZHfAQveZVSy/gm9V/N8Gb8EqAlH/GAairqz/8pkXgw7pU0J6CpVga52sMoeHjefiv xfFpkjhsgU17S8jlNkjHCWAVc2M0RRHQe5+z5C6TEk0xeOoY6Y2uC2cadT5uL8P5WwoF M1Og==; 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=1772344154; x=1772948954; 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=MKznFuVGnlK93q7ZBFPEY1HZ3DiPzjCwQhJWJgfjWYA=; b=nSoeHJf+7a0rl5ZO1BRpBPyPe+FbfXuC6cyZVtKnj9A2LUGd7k/q9Mn3YcS4IpV0mn 85xCILUd54NW274FuiLP+arijVDmS4TGMgLzql/IS6rheNsWuDuw4+gReBOMdA2789vd FTOlOpfLBgFDpOCWMErd1bCyH12Xmrmt/+q94ILufP9N7+nsq63rqXAUhphr05a/ujul 4P8HDIcD5v7DJ3LQgOOu+0cIhqLIjeS+4a74+B7U2t23E9AsizgEB11kB2H10TWynSeX 9XW0JCGyn4RWOa7qtmqfyU9yPutnZDeCsDsluPz4xNajIuERfXTPxKzimSsQ001OEZgU wNUw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1772344154; x=1772948954; 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=MKznFuVGnlK93q7ZBFPEY1HZ3DiPzjCwQhJWJgfjWYA=; b=lZ8FQDyMz13zB+EwvB4eiZrNzYdRRjD2ccFdDA55DQ6PBCJ34P0tRlwnp/YYktVkgp v1t9JB//1nBzyB2Qg//bB7Ltn+gN1IMBjd8Kt/BGqt5JCNnQtcN0OBZA7e6MDp/VhVII cD0BOi8zSXzHviLyGUZzmdC8XXMmTIx9LEewt9mWO2dh9gFkKG9Eu4BsO+DMNVUX2Kee A2Opj1bmkqD/+2W5bFSSwcNQvk+Tw7g0KAU7/kqKPKACNCr+8t1r6DGCkN2a6Jgqc8Ub P/t9a/+o+6Khx3+q0ushSrZuCJmZQGGBiunCWfti6wXwEowxp53VEr6UViom731HfCCt OAwA== X-Gm-Message-State: AOJu0YzQHjtgKoHFYVe08aDahwWfFFyvOx9QdGjWGkjbOqcoNlO9cPWZ ypPuhlq2oZMJ0g/XvMRnPqW1lj/vcoH8Tou7Q+HWgXInBChwSfDB4RgFbQmUFVl+aLO0FVmF6JV 2U8u86oxvS2rPxLgUXVjfbQ/FbkPX8u8= X-Gm-Gg: ATEYQzyQp/zWZJxNlJdij/PV54jsYXM3YC6uvu8OL9Cb3ah/CHkANzKw95dWM1zPbmV sqajzLByLutqohmQVoIFR76m+V5YqxuAwpyB778yn/9iD5eAxVBpnrE6CsM44z9SLTv3j5Bo5F/ 1gUi3TXVSseCAnhegULD641A3SebJYIHsE5H7phOQJEOw5X9psoqR05ppEbIUKnIjhf51kdHZSq 3qOlyJrILXkGU1SASm0mN/lSkbgxyw/mEQQyla/AfCV3V4iCQsd488eOG2mcy/8sQ+LIUrJmXAj OnUjqZs= X-Received: by 2002:a05:6820:228a:b0:66b:6862:18d5 with SMTP id 006d021491bc7-679fadb78f8mr4831618eaf.8.1772344153938; Sat, 28 Feb 2026 21:49:13 -0800 (PST) MIME-Version: 1.0 Received: by 2002:ac9:6158:0:b0:61f:8409:b416 with HTTP; Sat, 28 Feb 2026 21:49:13 -0800 (PST) In-Reply-To: References: From: "David G. Johnston" Date: Sat, 28 Feb 2026 22:49:13 -0700 X-Gm-Features: AaiRm52eKo_XBGEW5p49XDffW1zqk5TMgBhZQPdwLIDyJuPlJESLrEn49XbA-fE Message-ID: Subject: Re: Where the info is stored To: Igor Korot Cc: "pgsql-generallists.postgresql.org" Content-Type: multipart/alternative; boundary="000000000000b71ee0064bf007c3" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000b71ee0064bf007c3 Content-Type: text/plain; charset="UTF-8" On Saturday, February 28, 2026, Igor Korot wrote: > > draft=# WITH idx AS( SELECT i.indexrelid, i.indrelid, i.indnkeyatts, > i.indkey::int2[] AS indkey FROM pg_index i, pg_class ic, pg_namespace > ns > WHERE ic.oid = i.indexrelid AND ns.oid = ic.relnamespace AND > ns.nspname = 'public' AND ic.relname = 'leagues_new' ) > I doubt your index name is leagues_new. That is probably the table name. But ic.relname contains index names. David J. --000000000000b71ee0064bf007c3 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Saturday, February 28, 2026, Igor Korot <ikorot01@gmail.com> wrote:

draft=3D#=C2=A0 WITH idx AS(=C2=A0 SELECT i.indexrelid, i.indrelid, i.indnk= eyatts,
i.indkey::int2[] AS indkey FROM pg_index i, pg_class ic, pg_namespace
ns=C2=A0

WHERE ic.oid =3D i.indexrelid AND ns.oid =3D ic.re= lnamespace AND
ns.nspname =3D 'public' AND ic.relname =3D 'leagues_new' )<= /blockquote>


=
I doubt your index name is leagues_new.=C2=A0 That is probably the tab= le name.=C2=A0 But ic.relname contains index names.

David J. --000000000000b71ee0064bf007c3--