I am using version 8.0.3 on Windows 2003.
I would like to get a report out of PostgreSQL like the one below, EXCEPT
that I would like to associate a table name with the indexes this query
pulls
from pg_class.
Does anyone know how to do this?
-------- report query -------------
select relname,
relpages,
reltuples,
relpages,
relnatts
from pg_class
where relkind = 'i'
and relname not like 'sql_%'
and relname not like 'pg_%'
order by 1;