Thread

Reverse Engineering

Peter Harvey <pharvey@codebydesign.com> — 2001-08-23T21:02:16Z

There seem to be several ways to get at just about anything in the
Catalog Tables. The ODBC driver, psql, and pg_dump typically use
slightly diff sql and you guys have suggested even better ways. Forgive
me as I ask for more.

How do I determine the foriegn keys in a table?

I see pg_class.relfkeys and pg_class.relrefs. I am not sure what the
diff is between the two. In anycase; where can I go to find the
table/column(s) for each fk?

Having this info will allow me to accurately connect the tables in the
reverse engineered ERD. Very cool.

Peter