PGAdmin create ERD from explicitly selected tables?

Question

I have the ability to generate an ERD from an entire DB. My DB is huge and I want to focus on a subset of table relationships. Is this supported in PGAdmin?

Answer 1

it is possible to limit the recursion depth when generating relationship diagram in pgAdmin. Go to File -> Preferences -> "ERD tool" -> "Options" and change "Table Relation Depth" to desired value.

For example, if you set it to 1, then after right-clicking on given table and selecting "ERD For Table" only the direct relationships of that table will be shown.

It is also a bit more efficient than generating diagram for entire database/schema.

Checked in pgAdmin 8.2. settings screenshot