Re: ERD for single tables

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

In response to

Browse pgadmin-support by date

  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