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.



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.


CheckBox Instead

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


Rule Editor - Editing rule definition




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 btnRecordMacro Record button available in the status bar area, or use the Shift+Ctrl+R shortcut.

To stop recording, click the btnStopRecordMacro Stop button, or use the Shift+Ctrl+R shortcut.

To call the recorded macro, use the btnPlayMacro Play button, or use the Shift+Ctrl+P shortcut.