Rules Wizard (PostgreSQL)

Go Up to PostgreSQL Object Wizards

This wizard lets you build and submit a simple CREATE OR REPLACE RULE statement, defining a new database rule.

To create a new rule using a wizard:

1. Open a creation wizard for a rule. For details, see Opening an Object Wizard.
2. Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
   • Properties panel - Rules (PostgreSQL) - Properties.
   • Definition panel - Rules (PostgreSQL) - Definition.
   • DDL View panel - for details, see Previewing the DDL Generated to Create the New Object.
3. Finally, use the Execute button to create the object.

Rules (PostgreSQL) - Properties

When creating or editing a rule, this tab/panel lets you work with the following settings:

Setting	Availability and Description
Name	Lets you provide the name of the new role.
Parent Type	Select the type (TABLE or VIEW) of element to which this rule is to be applied.
Parent Schema and Parent Name	Select the schema and name of the parent object.
Connection Limit	Lets you provide the value for a CONNECTION LIMIT parameter, setting a limit on the number of concurrent connections the new role can make.
Name	Provide a name for the rule being created.
IsInstead	If unselected, a simple DO clause will be generated for the rule. If selected, a DO INSTEAD clause will be generated. The DO or DO INSTEAD clause command or commands are provided on the Definition tab/panel.
Event	Lets you select an AS ON event of SELECT, INSERT, UPDATE, or DELETE.

Rules (PostgreSQL) - Definition

When creating or editing a rule, this tab/panel lets you provide the DO or DO INSTEAD clause value, specifying the additional or alternative commands for this rule.