From: | Calle Hedberg <calle(dot)hedberg(at)gmail(dot)com> |
---|---|
To: | Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com> |
Cc: | "pgadmin-support lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org>, Pravesh Sharma <pravesh(dot)sharma(at)enterprisedb(dot)com> |
Subject: | Re: ERD for single tables |
Date: | 2023-12-12 10:57:53 |
Message-ID: | CAPB4dVgHy+2TChPS60WmMMD+CJV0YN3kOguK+8tUKBipkNfiSg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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(dot)toshniwal(at)enterprisedb(dot)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(dot)sharma(at)enterprisedb(dot)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,
>> Pravesh
>>
>> On Wed, Dec 6, 2023 at 11:43 PM Calle Hedberg <calle(dot)hedberg(at)gmail(dot)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 regards
>>> Calle
>>>
>>
>>
>> --
>>
>> <http://www.enterprisedb.com>
>>
>> Pravesh Sharma
>>
>> Software Engineer
>>
>> +91 9406461406
>>
>> www.enterprisedb.com
>>
>> Power to Postgres
>>
>> <https://www.linkedin.com/company/edbpostgres>
>> <https://twitter.com/edbpostgres?lang=en>
>> <https://www.facebook.com/EDBpostgres>
>> <https://www.instagram.com/EDBpostgres/>
>>
>
>
> --
> Thanks,
> Aditya Toshniwal
> pgAdmin Hacker | Sr. Software Architect | *enterprisedb.com*
> <https://www.enterprisedb.com/>
> "Don't Complain about Heat, Plant a TREE"
>
--
*Carl-Anders (Calle) Hedberg*
HISP
Researcher & Technical Specialist
Health Information Systems Programme – South Africa
Cell: +47 41461011 (Norway)
Iridium SatPhone: +8816-315-19119 (usually OFF)
E-mail1: calle(at)hisp(dot)org
E-mail2: calle(dot)hedberg(at)gmail(dot)com
Skype: calle_hedberg
From | Date | Subject | |
---|---|---|---|
Next Message | ed.silkworth | 2023-12-13 21:54:06 | pgAdmin 4 quit unexpectedly |
Previous Message | Aditya Toshniwal | 2023-12-07 05:59:14 | Re: ERD for single tables |