Online Documentation for SQL Manager for PostgreSQL

Creating/editing rule

Use the Rule tab of Rule Editor to create/edit a rule and specify its definition.

Name

Enter a name for the new rule, or modify the name of the rule being edited.

For table or view

Use the drop-down list to select the table/view the rule applies to.

Instead

This option indicates that the commands should be executed instead of the original command.

Event

Use the drop-down list to select the rule event: SELECT, UPDATE, INSERT, DELETE.

Condition

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.

Action

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.