Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Jad Cooper: "Your program is the best. I have only few hours but now I make very great data for my meeting".
Andrew Maclean: "I am really quite impressed with the software. You and your people are doing a wonderful job. I actually have spent a while researching PostgreSQL admin/code generators and yours seems to fit our needs nicely. Your interface is beautiful".

More

Add your opinion

PostgreSQL Maestro online Help

Prev Return to chapter overview Next

Create Rule Wizard

Create Rule Wizard guides you through the process of creating a new table rule.

The basic principles of Create Object Wizards in PostgreSQL Maestro are explained in a separate topic. Below you will find a description of wizard steps that are unique for the current object.

 

Specifying rule properties

Comment

The box allows you to set optional text to describe the new rule.

 

Event

Select the event that will fire the rule. The event is one of Select, Insert, Update, or Delete.

 

Instead

The checkbox indicates that the specified commands will be executed instead of the original command.

 

Condition

Here you can set 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.

 

 

Entering rule definition

At this step you can specify the SQL definition for the new rule. For any event (except the SELECT) the step is optional: you can do it later using a non-modal editor.
 



Prev Return to chapter overview Next