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.94.2) (envelope-from ) id 1ufgW0-00APi6-9c for pgsql-general@arkaria.postgresql.org; Sat, 26 Jul 2025 15:08:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1ufgVz-00A2VC-Cd for pgsql-general@arkaria.postgresql.org; Sat, 26 Jul 2025 15:08:47 +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.94.2) (envelope-from ) id 1ufgVz-00A2Ux-1b for pgsql-general@lists.postgresql.org; Sat, 26 Jul 2025 15:08:47 +0000 Received: from mail-ed1-x530.google.com ([2a00:1450:4864:20::530]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1ufgVv-000yWW-2K for pgsql-general@lists.postgresql.org; Sat, 26 Jul 2025 15:08:47 +0000 Received: by mail-ed1-x530.google.com with SMTP id 4fb4d7f45d1cf-60bfcada295so4954028a12.1 for ; Sat, 26 Jul 2025 08:08:44 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=fortnox.se; s=google; t=1753542522; x=1754147322; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=HGq6QweHKpPyuftRemrAl3EUNZQrPOpVUDCac+e+xns=; b=aZh3f9F1CnKPfLoGY5zyd7UF0MBAS6B87dT4ox5svf/Z2YJbMPXJYtJHQiU2Dfb/CB V7/LLxfbkrYHjjNAI+uz5RLN+YoGcIUWNKVGKGwKH3uT5Ia4a3eG3k6k8TMDDZPt6kPO k1C2QxV+SN9qkofFv/aGDA/ryLBaF0rDZDUcj64A/VlZQM8wKnxwWEpppwUzpIBeK+R3 BEGzM8bQaEC42RHlm0DafQjmr/gdG9HESSrmxEV0ffRlcESz0zTNZCGOX2/PbfiW1NK1 DwtwvotsnzVQW3hfuj3T5ApfKZolZLlNIF8mbLDdaUGGcuaGZk9GeaMXzucTy3PTIpoK 50Aw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1753542522; x=1754147322; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=HGq6QweHKpPyuftRemrAl3EUNZQrPOpVUDCac+e+xns=; b=mcBNtTFXffZtuAfH5QEtajfjiR6/swqYBqTtpQT9DG5Y0659M2cJ+umio3Nkru+Txr pCH0pZ38jQKW6WH9cZ6KkHFFKprf7VN9+NmG1WYj+k8lbjJB5Hhxu+M9zyA1UfnFTm5n kdNNuH8rq1f1x51RHJggbzrJzJg/TMiNsWDDGWSA8oiD26fQW9tsrDnbcXsNn6sz8EJ0 GXkU93H/QibBfzjFDjxdQEyyRzdVzLmJkHbfuSTHfBJkSkLOaIPxShJAN7EFATvPYfak zv9ySgcVG1vVa+rkEAf7QXQ1rZM+qk1s9vtjKePzDzAjYBE0QYMBLYvx+ve3Pk11bSr9 Iwmw== X-Gm-Message-State: AOJu0Yz595OfU6dvuPA3L+RtaYWy2vdxS4hYfre9eyDHP5DLeeLnOXJy TYjaOEB6BsC1kYDWmwgYqsvsLPQcNAJ87RBQuEYDK9FBPWQo5mclrt5/YNJVOLHdn/IjELH+WoX yoRIg/9Zf6mThFM1eKd1c9hpS3BbKAw/kr7b6yA+d+NVbuqVr4JzFn5vbJ86oc6ORFyiV6/CvMp 3RQXz2HoMYNhuviAmxgolxSQkAv6rdRb/IQbVcsemfog== X-Gm-Gg: ASbGncuHNH+dNPwqRHcg3zLoT6Ud6hcghMkVomKxl4ACu9oU7a53/eWZXEMxiG/neN8 ZTM5g8c4cacz6QDLf6FIwEnVKb++YIEWWEftr2S12tt7XoT9zgAxrWMrhiQn+xJZvuixC4qCytu vhayp+pN1sZk1shqsq/6j8K5+8Jj3mrJMbmxdzF4+yQyJUYTWTkh9/ttZyTEMCJwmbS9UcH4Tsu t0i2zTPplBXBAat X-Google-Smtp-Source: AGHT+IGhlMtWNa19hqpUqw8j4bEqFar+fSpQ/gpY7ic+RJfFKk0sDxS9bWopWCh9Cb1dub1K4OA3OgUAhcQxQWZb+VI= X-Received: by 2002:a17:906:c149:b0:ae6:c0a3:1606 with SMTP id a640c23a62f3a-af61c2b4156mr687804566b.7.1753542522489; Sat, 26 Jul 2025 08:08:42 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: =?UTF-8?Q?Robert_Sj=C3=B6blom?= Date: Sat, 26 Jul 2025 17:08:25 +0200 X-Gm-Features: Ac12FXwRKNezss4o5cRzV-NDZcfQCEE2UvmlJqCZPEGxvNLzUAp74g7ryF9w04I Message-ID: Subject: Re: Get info about the index To: Igor Korot Cc: "pgsql-generallists.postgresql.org" Content-Type: multipart/alternative; boundary="00000000000026f574063ad66fca" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000026f574063ad66fca Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Sat, 26 Jul 2025, 17: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 > > That guy has a full blown CREATE INDEX command and I will need to > parse it to get the info I need. > > Thank you. > What kind of info do you need? --=20 Inneh=C3=A5llet i detta e-postmeddelande =C3=A4r konfidentiellt och avsett = endast f=C3=B6r=20 adressaten.Varje spridning, kopiering eller utnyttjande av inneh=C3=A5llet = =C3=A4r=20 f=C3=B6rbjuden utan till=C3=A5telse av avs=C3=A4ndaren.=C2=A0Om detta medde= lande av misstag=20 g=C3=A5tt till fel adressat v=C3=A4nligen radera det ursprungliga meddeland= et och=20 underr=C3=A4tta avs=C3=A4ndaren via e-post --00000000000026f574063ad66fca Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


On Sat, 26 Jul 2025, 17:00 Igor = Korot, <ikorot01@gmail.com>= wrote:
Hi, ALL,=
Is there a better place to get the info about the index other than
https://www.postgresql.org/do= cs/current/view-pg-indexes.html

That guy has a full blown CREATE INDEX command and I will need to
parse it to get the info I need.

Thank you.

What kind of info do you need?

<= div dir=3D"auto">

Inneh=C3=A5llet i detta e-postmeddelande =C3=A4r konfidentiellt och= avsett endast f=C3=B6r adressaten.
Varje s= pridning, kopiering eller utnyttjande av inneh=C3=A5llet =C3=A4r f=C3=B6rbj= uden utan till=C3=A5telse av avs=C3=A4ndaren.=C2=A0Om detta meddelan= de av misstag g=C3=A5tt till fel adressat v=C3=A4nligen radera det ursprung= liga meddelandet och underr=C3=A4tta avs=C3=A4ndaren via e-post
--00000000000026f574063ad66fca--