PostgreSQL Table Rules
![Navicat for postgresql 12 download Navicat for postgresql 12 download](/uploads/1/1/8/5/118526355/344723452.png)
Navicat for PostgreSQL comes in handy for database administrators and for users who need to quickly manage and organize as many PostgreSQL connections as they want. PostgreSQL Table Foreign Keys. A foreign key specifies that the values in a column (or a group of columns) must match the values appearing in some row of another table. We say this maintains the referential integrity between two related tables. In the Foreign Keys tab, just simply click a foreign key field for editing. By using the foreign key.
The PostgreSQL rule system allows one to define an alternate action to be performed on insertions, updates, or deletions in database tables. Roughly speaking, a rule causes additional commands to be executed when a given command on a given table is executed.
Note: You must be the owner of a table to create or change rules for it.
In the Rules tab, just simply click a rule field for editing. By using the rule toolbar, you can create new, edit and delete the selected rule field.
Description | |
Add a rule to the table. | |
Delete Rule | Delete the selected rule. |
Use the Name edit box to set the rule name. This must be distinct from the name of any other rule for the same table. Multiple rules on the same table and same event type are applied in alphabetical name order.
Event
The event is one of SELECT, INSERT, UPDATE, or DELETE.
The event is one of SELECT, INSERT, UPDATE, or DELETE.
Do instead
This indicates that the commands should be executed instead of the original command. Otherwise, the commands should be executed in addition to the original command.
This indicates that the commands should be executed instead of the original command. Otherwise, the commands should be executed in addition to the original command.
Navicat For Postgresql
Condition
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.
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.
Definition
The command or commands that make up the rule action. Valid commands are SELECT, INSERT, UPDATE, DELETE, or NOTIFY.
The command or commands that make up the rule action. Valid commands are SELECT, INSERT, UPDATE, DELETE, or NOTIFY.
![Navicat for postgresql 12 download Navicat for postgresql 12 download](/uploads/1/1/8/5/118526355/344723452.png)
Navicat For Postgresql Download
Within condition and command, the special table names NEW and OLD may be used to refer to values in the referenced table. NEW is valid in ON INSERT and ON UPDATE rules to refer to the new row being inserted or updated. OLD is valid in ON UPDATE and ON DELETE rules to refer to the existing row being updated or deleted.
Navicat For Postgresql Crack
Comment
Define the comment for the rule.
Define the comment for the rule.