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
