No documentation was found matching the provided version! Browsing the latest one.

8.2.6. Quick objects creation

In pgModeler Plus, the user can quickly create some objects just by iterating over an object's pop-up menu. Currently, only the quick creation of constraints, indexes, and relationships is supported. To create an object, make sure to have a table or a set of columns on the same table selected, then right-click the selection to trigger the menu. The Quick create action will be enabled. The items available in the submenu vary according to the currently selected object.

For primary keys and unique keys, just hit the desired item in the menu or its related shortcut to instantiate the desired object by using the selected columns as the new constraint columns. For foreign key constraints, an additional step is taken, which is the selection of the table that the constraint will reference.

Now, for indexes and relationships, there is an additional submenu which lists, respectively, the index access method and the relationship types. For one-to-one, one-to-many, and many-to-many relationships, an extra menu entry is listed: Select table and Self-relationship. The first entry triggers the selection of the other table that will make part of the relationship being created. The second one causes the link being created to be a self-relationship, which means that the selected table is linked to itself.

The objects created by this plugin can have their name generation controlled via name patterns, as it happens with relationships. For constraints and index, one can specify name patterns in the plugin's configuration widget. Currently, only the attribute {table} is accepted, and causes the name of the parent table of the object to be replaced in the pattern during the name generation. For relationships, the name patterns as found in the relationship editing form and relationship settings are used.


May 6, 2025 at 12:04