The PostgreSQL rule system allows one to define an alternate action to be performed on insertions, updates, or deletions in database tables. Roughly speaking, a rule causes additional commands to be executed when a given command on a given table is executed.

Note: You must be the owner of a table to create or change rules for it.

Rules are managed on the Rules tab of the Table Designer. Just simply click/double-click a rule field for editing. Using the toolbar below, allowing you to create new, edit and delete the selected rule field.

Add Rule

To add a rule

• Open the table in the Table Designer.
• Open the Rules tab.
• Right-click and select the Add Rule from the popup menu or click the Add Rule from the toolbar.
• Edit rule properties.

Edit Rule

To edit a rule

• Open the table in the Table Designer.
• Open the Rules tab.
• Just simply click on the rule to edit.

Delete Rule

To delete a rule

• Open the table in the Table Designer.
• Open the Rules tab.
• Right-click on the rule to delete and select the Delete Rule from the popup menu or click the Delete Rule from the toolbar.
• Confirm deleting in the dialog window.

See also:
Setting Rule Name and Event
Setting Rule Condition and Definition