Search Postgresql Archives

Re: Get info about the index

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi, Christopher,



On Sat, Jul 26, 2025, 2:14 PM Christophe Pettus <xof@xxxxxxxxxxxx> 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. 


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux