Re: ERD for single tables

[Calle Hedberg]

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 
>> 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
>>>
>>
>>
>> --
>>
>> 
>>
>> Pravesh Sharma
>>
>> Software Engineer
>>
>> +91 9406461406
>>
>> www.enterprisedb.com
>>
>> Power to Postgres
>>
>> 
>> 
>> 
>> 
>>
>
>
> --
> Thanks,
> Aditya Toshniwal
> pgAdmin Hacker | Sr. Software Architect | *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

Re: ERD for single tables

[Aditya Toshniwal]

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 
> 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
>>
>
>
> --
>
> 
>
> Pravesh Sharma
>
> Software Engineer
>
> +91 9406461406
>
> www.enterprisedb.com
>
> Power to Postgres
>
> 
> 
> 
> 
>


-- 
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Sr. Software Architect | *enterprisedb.com*

"Don't Complain about Heat, Plant a TREE"

Re: ERD for single tables

[Pravesh Sharma]

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 
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
>


-- 



Pravesh Sharma

Software Engineer

+91 9406461406

www.enterprisedb.com

Power to Postgres

ERD for single tables

[Calle Hedberg]

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