Search code examples
databasepostgresqlerd

How to visualize the relationships between tables of a database schema?

I would like to generate an entity-relationship diagram (ERD) from an existing PostgreSQL database.

  • What is the recommended approach to do this?
  • Are there any built-in tools to do it? Or third-party alternatives?
Solution

  • We used DBVisualizer for that.

    Description: The References graph is a great feature as it automatically renders all primary/foreign key mappings (also called referential integrity constraints) in a graph style. The table nodes and relations are layed out automatically, with a number of layout modes available. The resulting graph is unique as it displays all information in an optimal and readable layout. from its site