Rules Wizard (PostgreSQL)

From RapidSQL
Jump to: navigation, search

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:
  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


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.


Provide a name for the rule being created.


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.


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.