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 1ufkvE-00BKfo-Qv for pgsql-general@arkaria.postgresql.org; Sat, 26 Jul 2025 19:51:09 +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 1ufkvD-00BoWt-TK for pgsql-general@arkaria.postgresql.org; Sat, 26 Jul 2025 19:51:08 +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.94.2) (envelope-from ) id 1ufkvD-00BoWk-J1 for pgsql-general@lists.postgresql.org; Sat, 26 Jul 2025 19:51:07 +0000 Received: from mail-pg1-x536.google.com ([2607:f8b0:4864:20::536]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1ufkvC-000vdg-0K for pgsql-general@lists.postgresql.org; Sat, 26 Jul 2025 19:51:06 +0000 Received: by mail-pg1-x536.google.com with SMTP id 41be03b00d2f7-b34a78bb6e7so2706377a12.3 for ; Sat, 26 Jul 2025 12:51:05 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1753559465; x=1754164265; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=m1sqxjUTGu0ppYThNjhCXvmXBev4C1KNuX7qk5npbvw=; b=JJwJgof/meDkhtVdVEYmP8ej+jRUkPyXGxVwU/2RBbp7sW/wU+yTi+DrZjz98kkPet DnkGSSVh1Z61+hYsIGffX1e3Y0eN7tStH0wr4A+Xg52BiPeg7PFPWDC0zI+f/2zbGtKj NShKnV/IeoOeWtfCeFXO0EYaJQP2qFH4ex0lJXa61rI00XcvMxHvSpYcfdDFSCFG/eHa YdEcbUdEREpZyVny6WXVJQEQjiD7dKkZUMZ4t/CfvffYbwNyb2ulRoFPWiTVGBgkAUUx NZi8ZITpLywmcb4ntMomwcUcUo9i3z/IVgWF3xxvA40YUlicP/hIKDNQCFaq1FPOKgd4 1H5w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1753559465; x=1754164265; h=content-transfer-encoding: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=m1sqxjUTGu0ppYThNjhCXvmXBev4C1KNuX7qk5npbvw=; b=MCc033SDiHmj1gQA0ckzOgxat7GPTJIvJYDDjpazjURHfdVIrxBIzFze3aO83SPeN/ JiK07NeDsNb5iZSUBvir5mgbV9oQUB4Ct4oHqrT7qLaBE8dfMNThmnX0KbEyq2xzxkJA AVueF6K/AbMFOD1EpPzvzNBTCFCPiszQvpkbYFxWy+vKIaKj3ncg6UdYDQ7ZsTT6+++D m3nilKCIadJw+Al4BiXLFA/QSOHGciwPluHv7aARXY94btAn8ztb+pn4WGYNEEmovFHp XfuZgTzly9bU3uecjeAurAYuf68p1jcakPmHoZ5yizlBf0IzZKP7Q0TiuiZ7wqUg0Clq AUtA== X-Forwarded-Encrypted: i=1; AJvYcCXyCF2SH/FOiLdUzUdu4RnpWNeahUruGrcJ/7LuVsNn0DNW+BDcA0/VXDB5bcpnUjk1ESTcayxCRs6TUU5L@lists.postgresql.org X-Gm-Message-State: AOJu0YzRreaBDN4DmJtRHqmAet2JP9n7snTojc1HhwOJjx6ij6kjMkbC YeAEa9hoYvkRxWUNUjiaHYtWaeAImrIgyzcaMc9Ep5aCrxs5go/NwDX7J/Ah9/Fha8Hivv3HETV ZEjFAcLh8BxpfYVQ4iRspcLm0W7+rO2k= X-Gm-Gg: ASbGnctgZV8ivlnkmiIYAAXSKtItBTFap/0hbx3bcH4hi6riKvO17B3iwQNXZXR3OHp GmNvBPtZOdnUDsK6H8GUqjMcwIylw204XSXB7ICPy0QKsvQqyAhM3fYHKF8kjIhPIEF7G2TdFPI 1TbqyT76KtlBdQb2zlXWNdD9npVcd8OxY7tc+azkq8LdvQ7Blocx/cSHLYYTR0giqrcLULx/tOX McoNvESKTMh2Fr41v2i/kfXlBfugwEtFUhL9OM= X-Google-Smtp-Source: AGHT+IFZ/R6ldDi477+Us673ypejxq7KvqDVvtPn6JC9ZMOa0dFYbm4wdoxxPmHYazrzoZtU5cNTAIHgm/N6KmQGI2o= X-Received: by 2002:a17:90b:518d:b0:312:26d9:d5b2 with SMTP id 98e67ed59e1d1-31e776223a5mr11849845a91.0.1753559464751; Sat, 26 Jul 2025 12:51:04 -0700 (PDT) MIME-Version: 1.0 References: <090d8588-e74e-4436-8f69-05ce8624379b@aklaver.com> <0BC8BEBF-3B1F-4E69-A1B9-CCCDF9617168@thebuild.com> In-Reply-To: From: Jon Zeppieri Date: Sat, 26 Jul 2025 15:50:53 -0400 X-Gm-Features: Ac12FXxYqg9ETsqnL44uJhIORWYx7Y1Vs4LGzsOHwN9rDaYV6_HIWXUtOOW9kB0 Message-ID: Subject: Re: Get info about the index To: Igor Korot Cc: Christophe Pettus , Adrian Klaver , "pgsql-generallists.postgresql.org" Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sat, Jul 26, 2025 at 3:13=E2=80=AFPM Igor Korot wro= te: > > I didn't find the sorting for the field. > > Can you help? The pg_index_column_has_property() can provide this information. E.g., select pg_index_column_has_property('my_index'::regclass, 2, 'desc');