Online Documentation for SQL Manager for PostgreSQL
Use the Rule tab of Rule Editor to create/edit a rule and specify its definition.
Enter a name for the new rule, or modify the name of the rule being edited.
For table or view
This option indicates that the commands should be executed instead of the original command.
Use the drop-down list to select the rule event: SELECT, UPDATE, INSERT, DELETE.
Specify the condition that defines the rule using arithmetic and relational operators. This can be any SQL conditional expression (returning boolean). The condition expression may not refer to any tables except NEW and OLD, and may not contain aggregate functions.
This area represents the action(s) to be taken upon the specified event occurrence. Specify the command or commands that make up the rule action. Valid commands are SELECT, INSERT, UPDATE, DELETE, or NOTIFY.
For your convenience the syntax highlight, code folding and a number of other features for efficient SQL editing are implemented. For details see Working with Query Data area and Using the context menu.
The possibility to use macros is also implemented.
To start recording a macro, click the Record button available in the status bar area, or use the Shift+Ctrl+R shortcut.
To stop recording, click the Stop button, or use the Shift+Ctrl+R shortcut.
To call the recorded macro, use the Play button, or use the Shift+Ctrl+P shortcut.