> 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.