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

Subscribe to our news:
Partners
Testimonials
Simon Pills: "Someone finally invented an intuitively used and easily customized PostgreSQL database administration tool! Keep up the good work. I will be in touch. I am able to do this horrendous work because your software enabled me to create a new database with all necessary objects in several minutes! I am sure that I have found what I really need".
Daryl Joubert: "I am evaluating your PostgreSQL Maestro product for purchase by my company and thus far I am very impressed! I really like the easy, intuitive and productive user interface and feature set. I am also evaluating a number of other products for PostgreSQL database design and maintenence but thus far SQLMaestro stands head and shoulders above the rest".

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