Thread: ERD for single tables
Hi,
I have a large and very complicated database, where the complete ERD is so large that it is very hard to find anything (even with a 45" monitor and zooming out). Hundreds of tables, hundreds or relationships.
I have tried to create an ERD for a single table only, but that does not seem to work - every time I do it, the result is a complete ERD for the whole database.
Is this a bug, or have I missed something? I'm selecting one table, right-click and select "ERD for Table". But I get the complete diagram...
Best regards
Calle
Hi Calle,
--
By default, pgAdmin creates ERD for all the related tables. To generate ERD for a single table, you can set the value at Preferences -> ERD tool -> Options -> Table Relation Depth to 0.
Please let me know if this resolves the issue.
Regards,
Pravesh
On Wed, Dec 6, 2023 at 11:43 PM Calle Hedberg <calle.hedberg@gmail.com> wrote:
Hi,I have a large and very complicated database, where the complete ERD is so large that it is very hard to find anything (even with a 45" monitor and zooming out). Hundreds of tables, hundreds or relationships.I have tried to create an ERD for a single table only, but that does not seem to work - every time I do it, the result is a complete ERD for the whole database.Is this a bug, or have I missed something? I'm selecting one table, right-click and select "ERD for Table". But I get the complete diagram...Best regardsCalle
Pravesh Sharma Software Engineer +91 9406461406 Power to Postgres | |
Hi Calle,
You can try the solution mentioned by Pravesh.
Alternatively, pgAdmin ERD also allows you to drag the table and drop it in ERD. So you can start with a blank ERD and drag the tables you need.
On Thu, Dec 7, 2023 at 9:13 AM Pravesh Sharma <pravesh.sharma@enterprisedb.com> wrote:
Hi Calle,By default, pgAdmin creates ERD for all the related tables. To generate ERD for a single table, you can set the value at Preferences -> ERD tool -> Options -> Table Relation Depth to 0.Please let me know if this resolves the issue.Regards,PraveshOn Wed, Dec 6, 2023 at 11:43 PM Calle Hedberg <calle.hedberg@gmail.com> wrote:Hi,I have a large and very complicated database, where the complete ERD is so large that it is very hard to find anything (even with a 45" monitor and zooming out). Hundreds of tables, hundreds or relationships.I have tried to create an ERD for a single table only, but that does not seem to work - every time I do it, the result is a complete ERD for the whole database.Is this a bug, or have I missed something? I'm selecting one table, right-click and select "ERD for Table". But I get the complete diagram...Best regardsCalle--
Pravesh Sharma
Software Engineer
+91 9406461406
Power to Postgres
Thanks,
Aditya Toshniwal
"Don't Complain about Heat, Plant a TREE"
Hi,
Changing the table relation depth to 0 or to 1 resolved my issue. THANKS!!
Regards & Merry Christmas to all
Calle
On Thu, 7 Dec 2023 at 06:59, Aditya Toshniwal <aditya.toshniwal@enterprisedb.com> wrote:
Hi Calle,You can try the solution mentioned by Pravesh.Alternatively, pgAdmin ERD also allows you to drag the table and drop it in ERD. So you can start with a blank ERD and drag the tables you need.On Thu, Dec 7, 2023 at 9:13 AM Pravesh Sharma <pravesh.sharma@enterprisedb.com> wrote:Hi Calle,By default, pgAdmin creates ERD for all the related tables. To generate ERD for a single table, you can set the value at Preferences -> ERD tool -> Options -> Table Relation Depth to 0.Please let me know if this resolves the issue.Regards,PraveshOn Wed, Dec 6, 2023 at 11:43 PM Calle Hedberg <calle.hedberg@gmail.com> wrote:Hi,I have a large and very complicated database, where the complete ERD is so large that it is very hard to find anything (even with a 45" monitor and zooming out). Hundreds of tables, hundreds or relationships.I have tried to create an ERD for a single table only, but that does not seem to work - every time I do it, the result is a complete ERD for the whole database.Is this a bug, or have I missed something? I'm selecting one table, right-click and select "ERD for Table". But I get the complete diagram...Best regardsCalle--
Pravesh Sharma
Software Engineer
+91 9406461406
Power to Postgres
--Thanks,Aditya Toshniwal"Don't Complain about Heat, Plant a TREE"
HISP
Researcher & Technical Specialist
Health Information Systems Programme – South Africa
Cell: +47 41461011 (Norway)
Iridium SatPhone: +8816-315-19119 (usually OFF)
E-mail1: calle@hisp.org
E-mail2: calle.hedberg@gmail.com
Skype: calle_hedberg