Horton

Re: Reverse Engineering

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Hannu Krosing <hannu@tm.ee>
Cc: Peter Harvey <pharvey@codebydesign.com>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2001-08-23T13:17:25Z
Lists: 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