"Lane Van Ingen" <lvaningen@esncc.com> writes:
> I would like to associate a table name with the indexes this query
> pulls from pg_class.
You have to join against pg_index and then back to pg_class.
See the system catalogs documentation for your PG version, eg
http://www.postgresql.org/docs/8.0/static/catalogs.html
regards, tom lane