pgadmin4
pgadmin4 copied to clipboard
ERD tool: Allow/show foreign keys linking to a another schema
From the Manual:
The ERD for schema will fetch all the tables from a schema and plot them with foreign key links. If any table refers to a table in another schema, then that link/foreign key will be removed.
It would be very useful if the ERD tool would allow creation and display of links to tables in another schema. Perhaps by drawing it as e.g. a diamond with a number in it + a list with a reference to the tables in other schemas? This is similar to how it is done in some larger electrical diagrams. You could also display the name of the other table when hovering the mouse over the referece (diamond) symbol.