Large diagrams are often easier to understand when broken down into smaller, related groups of tables. For example:

• Users & Authentication

• Orders & Products

• Billing & Payments

How to do it:

• Identify logical modules or domains in your database.

• Create smaller diagrams focused on those areas.

• Export each separately

  OR

  pgAdmin is not optimized for large ERD exports. Consider using one of the following tools instead:

  1. DBeaver (Free & Open Source)

  • Connects directly to PostgreSQL

  • Allows ERD generation and export to PDF/PNG

  • Supports filtering tables and customizing layouts

  2. dbdiagram.io

  • Simple and clean UI

  • Supports PostgreSQL syntax

  • Great for documentation and sharing

  3. Draw.io or Lucidchart

  • Drag-and-drop manual diagramming

  • High quality for presentations and documentation

  4. SchemaSpy

  • Generates interactive HTML-based documentation, including ERDs

  5. JetBrains DataGrip (Commercial)

  • Professional-grade ERD tools

  • Visual grouping and high-quality exports