Thread

1. Reverse Engineering

   Peter Harvey <pharvey@codebydesign.com> — 2001-08-23T05:27:23Z

   Great progress today on my Reverse Engineering efforts. However; I have
   some comments.
   
   1. How can I switch databases (where I would normally use USE)?
   
   2. How do I determine the AccessMethod specified when an index was
   created?
   
   3. It would be cool if the catalog objects had comments on them in
   pg_description. Very few do.
   
   Peter
   
   
   
   
   

2. Re: Reverse Engineering

   Hannu Krosing <hannu@tm.ee> — 2001-08-23T06:59:14Z

   Peter Harvey wrote:
   > 
   > Great progress today on my Reverse Engineering efforts. However; I have
   > some comments.
   > 
   > 1. How can I switch databases (where I would normally use USE)?
   
   You just open another connection .
   
   If you mean psql jou do 
   \c otherdatabasename
   
   > 2. How do I determine the AccessMethod specified when an index was
   > created?
   
   you can parse it from pg_indexes.indexdef 
   
   A great source for reverse engineering is source of pg_dump as it has 
   to do all the "reverse engineering" in order to dump everything.
   
   > 3. It would be cool if the catalog objects had comments on them in
   > pg_description. Very few do.
   
   Yes it would :)
   
   -------------
   Hannu
   
   

3. Re: Reverse Engineering

   Tom Lane <tgl@sss.pgh.pa.us> — 2001-08-23T13:17:25Z

   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