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.toshni...@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.sha...@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,
>> Pravesh
>>
>> On Wed, Dec 6, 2023 at 11:43 PM Calle Hedberg <calle.hedb...@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 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: ca...@hisp.org

E-mail2: calle.hedb...@gmail.com

Skype:  calle_hedberg

Reply via email to