MIME-Version: 1.0
References: <CA+FnnTw2ouEQKSKzQ_SNo8efWE8wEqjr9Ux-F-wbR+y=Pn6bGg@mail.gmail.com>
 <090d8588-e74e-4436-8f69-05ce8624379b@aklaver.com>
In-Reply-To: <090d8588-e74e-4436-8f69-05ce8624379b@aklaver.com>
From: Igor Korot <ikorot01@gmail.com>
Date: Sat, 26 Jul 2025 12:41:48 -0400
Message-ID: <CA+FnnTyKb0cLp9GF3YENoBZ4LVW3db_RSGR99BPFnA4BZtc8kQ@mail.gmail.com>
Subject: Re: Get info about the index
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/CA%2BFnnTyKb0cLp9GF3YENoBZ4LVW3db_RSGR99BPFnA4BZtc8kQ%40mail.gmail.com>
Precedence: bulk

Adrian,

On Sat, Jul 26, 2025 at 11:08=E2=80=AFAM Adrian Klaver
<adrian.klaver@aklaver.com> wrote:
>
> On 7/26/25 08:00, Igor Korot wrote:
> > Hi, ALL,
> > Is there a better place to get the info about the index other than
> > https://www.postgresql.org/docs/current/view-pg-indexes.html
>
> What information do you need?

This is the command for creating the index:
https://www.postgresql.org/docs/current/sql-createindex.html.

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

I don't want to parse the command since I'm sure I can query the DB
to get the info.

Thank you..

>
> >
> > That guy has a full blown CREATE INDEX command and I will need to
> > parse it to get the info I need.
> >
> > Thank you.
> >
> >
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com