MIME-Version: 1.0
References: <CA+FnnTw2ouEQKSKzQ_SNo8efWE8wEqjr9Ux-F-wbR+y=Pn6bGg@mail.gmail.com>
 <090d8588-e74e-4436-8f69-05ce8624379b@aklaver.com> <CA+FnnTyKb0cLp9GF3YENoBZ4LVW3db_RSGR99BPFnA4BZtc8kQ@mail.gmail.com>
 <0BC8BEBF-3B1F-4E69-A1B9-CCCDF9617168@thebuild.com>
In-Reply-To: <0BC8BEBF-3B1F-4E69-A1B9-CCCDF9617168@thebuild.com>
From: Igor Korot <ikorot01@gmail.com>
Date: Sat, 26 Jul 2025 15:13:23 -0400
Message-ID: <CA+FnnTy8bdXxFZBmFfm1oNMQLVxL-+UmkX8EecbLB0MehX8gFw@mail.gmail.com>
Subject: Re: Get info about the index
To: Christophe Pettus <xof@thebuild.com>
Cc: Adrian Klaver <adrian.klaver@aklaver.com>, 
	"pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000d8f18e063ad9daf7"
Archived-At: <https://www.postgresql.org/message-id/CA%2BFnnTy8bdXxFZBmFfm1oNMQLVxL-%2BUmkX8EecbLB0MehX8gFw%40mail.gmail.com>
Precedence: bulk

--000000000000d8f18e063ad9daf7
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi, Christopher,


On Sat, Jul 26, 2025, 2:14=E2=80=AFPM Christophe Pettus <xof@thebuild.com> =
wrote:

>
>
> > I want to know all individual things:
> > - whether the index is unique.
> > - what type of index it is
> > - whether the field is ASC or DESC.
> > - all other individual arams
>
> pg_index is the source for those.  The one exception is the access method
> for the index, which is in pg_class.


I didn't find the sorting for the field.

Can you help?

Thank you.

--000000000000d8f18e063ad9daf7
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto"><div>Hi, Christopher,<div dir=3D"auto"><br></div><br><br>=
<div class=3D"gmail_quote gmail_quote_container"><div dir=3D"ltr" class=3D"=
gmail_attr">On Sat, Jul 26, 2025, 2:14=E2=80=AFPM Christophe Pettus &lt;<a =
href=3D"mailto:xof@thebuild.com">xof@thebuild.com</a>&gt; wrote:<br></div><=
blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px=
 #ccc solid;padding-left:1ex"><br>
<br>
&gt; I want to know all individual things:<br>
&gt; - whether the index is unique.<br>
&gt; - what type of index it is<br>
&gt; - whether the field is ASC or DESC.<br>
&gt; - all other individual arams<br>
<br>
pg_index is the source for those.=C2=A0 The one exception is the access met=
hod for the index, which is in pg_class.</blockquote></div></div><div dir=
=3D"auto"><br></div><div dir=3D"auto">I didn&#39;t find the sorting for the=
 field.</div><div dir=3D"auto"><br></div><div dir=3D"auto">Can you help?</d=
iv><div dir=3D"auto"><br></div><div dir=3D"auto">Thank you.=C2=A0</div><div=
 dir=3D"auto"><br></div><div dir=3D"auto"></div></div>

--000000000000d8f18e063ad9daf7--