Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Jad Cooper: "Your program is the best. I have only few hours but now I make very great data for my meeting".
Shafiq Far: "Just wanted to let you know that I think the SQL Maestro for Postgres is excellent. We've tried a variety over the past few years and none are even close to yours. Well done".

More

Add your opinion

PostgreSQL Maestro online Help

Prev Return to chapter overview Next

Domain Editor

Domain Editor is opened automatically after a new Domain is created and is available on editing the existing one (see Edit Domain for details).
 

The basic principles of Object Editors in PostgreSQL Maestro are explained in a separate topic. Below you will find a description of editor tabs that are unique for the current object.

 

Domain Editor provides you with an ability to edit Domain properties. The Properties tab allows you to change the Domain name, the Domain owner, etc. You can also find the OID there.

 

 

 

The Checks tab of the Domain Editor represents the domain check list. Check clauses specify integrity constraints or tests to be satisfied by values of the domain. Each constraint must be an expression producing a Boolean result. It should use the name VALUE to refer to the value being tested.

 

The tab includes three columns: Check name, Condition and Comment.

 

Check name

Here you can specify the domain check name.

 

Condition

The column stores the condition which must be complied with by a new or updated values of the domain for an insert or update operations to succeed.

 

New comment

This field stores a comment to the domain check.

 

You can also use Navigation bar to manage Domain checks.

 

Name

Here you can view the Domain name. The name of the Domain must be unique among all the Domain names in the schema.
 

Owner

By default, only the owner of an object can perform various operations with the object. In order to allow other users to operate it, privileges must be granted. (However, users that have the superuser attribute can always access any object.)

 

Comment

This field stores a comment to the Domain.

 

OID

The field stores the OID (object identifier) of the domain. OID can be defined as a serial number that is automatically added by PostgreSQL to all domains.

 

The Base Type represents the SQL Server supplied data type on which the alias data type is based.

 

Not Null

The checkbox indicates that the values of the Domain are not allowed to be null.

 

Default Value

The field is meant to specify a default value for the domain data type.

 

 

To apply the changes, select the Apply Changes item in the Navigation bar or use Ctrl+F9 or Ctrl+F7 shortcut keys.

 

It is also possible to modify object properties without opening the object editor: use the Object Properties item of the popup menu of the selected object from the explorer tree.



Prev Return to chapter overview Next