mike(dot)griffin(at)mygenerationsoftware(dot)com writes:
> I noticed that there is no INFORMATION_SCHEMA.Indexes ? isn't there
> supposed to be one.
Nope. Indexes are not a concept used in the SQL spec at all (they
consider 'em an implementation detail), so they'd hardly want to
standardize a view to describe 'em.
You can look at the constraints views to find out about unique and
primary key constraints, which are implemented by indexes in PG.
But that won't tell you about indexes made by CREATE INDEX.
regards, tom lane