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:
- Open a creation wizard for a rule. For details, see Opening an Object Wizard.
- 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.
- 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.