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