Ubuntu manuals

Provided by: manpages-zh_1.5.2-1_all

NAME

       ALTER DOMAIN -

SYNOPSIS

       ALTER DOMAIN name
           { SET DEFAULT expression | DROP DEFAULT }
       ALTER DOMAIN name
           { SET | DROP } NOT NULL
       ALTER DOMAIN name
           ADD domain_constraint
       ALTER DOMAIN name
           DROP CONSTRAINT constraint_name [ RESTRICT | CASCADE ]
       ALTER DOMAIN name
           OWNER TO new_owner

DESCRIPTION

       ALTER DOMAIN

       SET/DROP DEFAULT
                INSERT

       SET/DROP NOT NULL
                NULL  NULL   SET NOT NULL

       ADD domain_constraint
                CREATE DOMAIN [create_domain(7)]

       DROP CONSTRAINT

       OWNER

         ALTER DOMAIN ALTER DOMAIN OWNER

PARAMETERS

       name

       domain_constraint

       constraint_name

       CASCADE

       RESTRICT

       new_owner

EXAMPLES

         NOT NULL

       ALTER DOMAIN zipcode SET NOT NULL;

         NOT NULL

       ALTER DOMAIN zipcode DROP NOT NULL;

       ALTER DOMAIN zipcode ADD CONSTRAINT zipchk CHECK (char_length(VALUE) = 5);

       ALTER DOMAIN zipcode DROP CONSTRAINT zipchk;

COMPATIBILITY

       ALTER DOMAIN  SQL99  OWNER  PostgreSQL

       Postgresql  <laser@pgsqldb.org>