workerjoe
Reputation: 2663
How to discover associations between tables in a PostgreSQL database?
I'm dealing with a huge ERP database, hundreds of tables, and am having trouble figuring out how one entity is referenced from another. Let's call them the "sale" table and the "shipment" table. Each has FK relationships with numerous other tables, but no FK links either one to the other, and no obvious associative table is linked to both.
- Is there any good way using SQL or the psql command line to discover the chains of relationships that connect the two tables?
- Is there any good way to discover the chains that connect a specific row or PK of "sale" and a specific row/PK of "shipment"?
Upvotes: 0
Views: 411
Answers (1)
Related Questions
- How do I discover the structure of a PostgreSQL database?
- Identify database records that point to each other
- Finding common relationships in Postgres SQL
- How to determine relationship (1:1, 1:n, n:m) between tables when reverse engineering
- How to spot the relationship in RDBMS?
- PostgreSQL - is there any way that I can find all of the foreign keys that reference a certain table?
- How can I find tables which reference a particular row via a foreign key?
- How to find tables where more than one column references the same table in postgresql
- postgresql difficult(for me) query
- Introspect postgresql 8.3 to find foreign keys