Reverse Engineering
Started by Peter Harveyover 24 years ago1 messages
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