| PostgreSQL 8.0.1 Documentation | ||||
|---|---|---|---|---|
| Prev | Fast Backward | Fast Forward | Next | |
ALTER DOMAIN
Synopsis
Description
ALTER DOMAIN changes the definition of an existing domain. There are several sub-forms:
- SET/DROP DEFAULT
These forms set or remove the default value for a domain. Note that defaults only apply to subsequent INSERT commands; they do not affect rows already in a table using the domain.
- SET/DROP NOT NULL
These forms change whether a domain is marked to allow NULL values or to reject NULL values. You may only SET NOT NULL when the columns using the domain contain no null values.
- ADD domain_constraint
This form adds a new constraint to a domain using the same syntax as CREATE DOMAIN. This will only succeed if all columns using the domain satisfy the new constraint.
- DROP CONSTRAINT
This form drops constraints on a domain.
- OWNER
This form changes the owner of the domain to the specified user.
You must own the domain to use ALTER DOMAIN; except for ALTER DOMAIN OWNER, which may only be executed by a superuser.
Parameters
- name
The name (possibly schema-qualified) of an existing domain to alter.
- domain_constraint
New domain constraint for the domain.
- constraint_name
Name of an existing constraint to drop.
- CASCADE
Automatically drop objects that depend on the constraint.
- RESTRICT
Refuse to drop the constraint if there are any dependent objects. This is the default behavior.
- new_owner
The user name of the new owner of the domain.
Examples
To add a NOT NULL constraint to a domain:
To remove a NOT NULL constraint from a domain:
To add a check constraint to a domain:
To remove a check constraint from a domain:
