Observe related data with Master-Detail Browser
This browser, available in dbForge Studio for PostgreSQL, helps you view and analyze related data in:
- Parent tables or views
- Related child tables or views
- Self-referencing tables
To open this browser, go to the Database menu, and then click Master-Detail Browser. Alternatively,
you may right-click the required database objects in the Database Explorer window, select Send to,
and then click Master-Detail Browser. Upon the launch, a separate master-detail document with
the *.mdet extension will be created automatically.
Working in Design View
On the left, a Database Explorer window is displayed, from which you can drag
tables and views onto a diagram. Arrows between tables or views show existing relations between them.
Besides, you can create links between columns yourself. To create a link, drag a column from one object
to a column in the other object that you want to link. Right-click the link to change its direction
or to remove it completely.
A self-referencing table is a table that is a parent and a dependent in the same referential constraint.
In other words, in such tables a foreign key constraint can reference columns within the same table.
Sorting and filtering data
Data can be easily sorted in both master and detail tables. To sort data by a particular column,
click the column header. Clicking on the cell removes sorting from all other columns, sets
sorting order to ascending if it has not been set before, or changes the sorting direction.
Data can be filtered only in detail tables. To apply filtering to a column, click the funnel button
on the header of a column you want to apply filtering to. The drop-down list opens with a set of
values encountered in this column and the universal items such as All, Custom, Blanks, and Non Blanks.
To view only rows containing Blanks (NULLs), Non Blanks (not NULLs), or a certain value, select the
corresponding item in the list. To set a custom filter, select Custom and create a filter in the
opened Custom AutoFilter window.
Get your free trial of dbForge Studio for PostgreSQL to evaluate
all the advantages of Master-Detail Browser, where all data can be conveniently visualized with
Design and Data application views.