Online Documentation for SQL Manager for PostgreSQL

Editing check definition


Use the Check tab of Check Editor to create/edit a check constraint and specify its properties.

 

Check name

Enter a name for the new check, or modify the name of the check being edited.

 

Check Editor - Editing check definition

 

CheckBox Not validated (for Postgres 9.2 and higher)

If this option is selected then a check can initially be added to a large existing table without checking its initial contents, but new tuples must comply with it.

 

CheckBox Non-inheritable (for Postgres 9.2 and higher)

If this option is selected then a check will not propagate to child tables.

 

Condition

This area represents the condition implied by the check constraint.

You can specify any logical (Boolean) expression that returns TRUE or FALSE based on the logical operators. For example, salary >= 15000 AND salary <= 100000.

 

The Description field allows you to view and edit the comment for the object.

 

For your convenience the syntax highlight, code completion and a number of other features for efficient SQL editing are implemented. For details see Working with Query Data area and Using the context menu.