Reverse Engineering
Peter Harvey <pharvey@codebydesign.com>
From: Peter Harvey <pharvey@codebydesign.com>
To: pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2001-08-23T21:02:16Z
Lists: pgsql-hackers
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