Re: Reverse Engineering - Mailing list pgsql-hackers

Hannu Krosing <hannu@tm.ee> writes:
> Peter Harvey wrote:
>> 2. How do I determine the AccessMethod specified when an index was
>> created?

> you can parse it from pg_indexes.indexdef 

... which relies on pg_get_indexdef(index OID).

Or, look at pg_class.relam, which is zero for regular tables and a pg_am
OID for indexes.
        regards, tom lane